R4_Debris_Removal_Formulas_Exploration

1 Debris Model Analysis

This report is split into multiple sections, which you can access with the tabs below. There is a summary, then Vegetative Debris and Construction Debris, and an Appendix. You can switch between the tabs/analysis by clicking the tab headers below: ______________________________________________________________________

1.1 BLUF

We support the following formulas for Vegetative debris prediction and Construction debris predictions:

1.1.1 Vegetative

\[Cost = 10^{(log10( Cubic Yards )*0.73076 + 2.5827 )}\]

1.1.2 Construction

\[Cost = 10^( log10 (Cubic Yards )*0.54892 + 3.5681)\] The analysis and explanation for each of these follows below. The multipliers(cost per cubic yard) and the intercept (base costs for removal) are derived from linear regression.

Use the table of contents to the left, and the analysis tabs to view a given section.

1.1.3 Debris Data

Below is data aggregated to separate instances of debris removal at the county level. We briefly view the data below, and will use Gross_Cost and Quantity (in Cubic Yards) to calculate ratios and relationships like ‘cost per cubic yard’ across the counties and projects in the dataset. We are including all regions in this version of the analysis, to be able to fit more robust relationships between cost and quantity.

• Data Range: 2016-2024
• Regions: (ALL)
• Number of Debris Removals: 14384

Disaster_Number	Incident_Type	Declaration_Date	Region_Number	State	Applicant_Damage_CatA_Removal_Id	Applicant_Damage_Id	Applicant_Project_Id	Applicant_Id	Applicant_Name	Event_Id	County	FIPS	Gross_Cost	Net_Cost	Work_Category	Location_Type	Debris_Type	Debris_Type_Other	Quantity	Quantity_Unit_Of_Measure	Start_Date	End_Date
4673	Hurricane	2022-09-29	4	Florida	42697	1305611	708608	201362	Florida Division of Emergency Management	1732	Leon County	12073	4208286.2	4208286.2	A	Public ROW	Vegetative Debris	NA	48.6128	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	41281	1256239	687485	201362	Florida Division of Emergency Management	1732	Leon County	12073	65804428.0	65804428.0	A	Other Public Property	Vegetative Debris	NA	100000.0000	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42599	1305614	708612	201362	Florida Division of Emergency Management	1732	Leon County	12073	2082260.3	2082260.3	A	Public ROW	Vegetative Debris	NA	3266.6500	Cubic Yard	2022-12-08	2023-01-24
4673	Hurricane	2022-09-29	4	Florida	42607	1305614	708612	201362	Florida Division of Emergency Management	1732	Leon County	12073	2082260.3	2082260.3	A	Public ROW	Vegetative Debris	NA	5999.5400	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42422	1265535	692446	201362	Florida Division of Emergency Management	1732	Leon County	12073	41109052.2	41109052.2	A	Waterway	Vegetative Debris	NA	87744.5500	Cubic Yard	2022-12-08	2023-01-24
4673	Hurricane	2022-09-29	4	Florida	41403	1259472	689433	201362	Florida Division of Emergency Management	1732	Leon County	12073	41768603.2	41768603.2	A	Public ROW	Vegetative Debris	NA	1500000.0000	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42431	1265535	692446	201362	Florida Division of Emergency Management	1732	Leon County	12073	41109052.2	41109052.2	A	Waterway	Vegetative Debris	NA	140391.2800	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42452	1304851	708168	201362	Florida Division of Emergency Management	1732	Leon County	12073	8306922.7	8306922.7	A	Public ROW	Vegetative Debris	NA	7790.0000	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42445	1304851	708168	201362	Florida Division of Emergency Management	1732	Leon County	12073	8306922.7	8306922.7	A	Public ROW	Vegetative Debris	NA	3819.0000	Cubic Yard	2022-12-08	2023-02-09
4673	Hurricane	2022-09-29	4	Florida	42405	1305219	708411	201362	Florida Division of Emergency Management	1732	Leon County	12073	15657618.7	15657618.7	A	Public ROW	Vegetative Debris	NA	352620.0000	Cubic Yard	2022-12-08	2023-02-15
4673	Hurricane	2022-09-29	4	Florida	42345	1305219	708411	201362	Florida Division of Emergency Management	1732	Leon County	12073	15657618.7	15657618.7	A	Public ROW	Vegetative Debris	NA	286696.9400	Cubic Yard	NA	NA
4673	Hurricane	2022-09-29	4	Florida	42686	1305611	708608	201362	Florida Division of Emergency Management	1732	Leon County	12073	4208286.2	4208286.2	A	Public ROW	Vegetative Debris	NA	28336.7000	Cubic Yard	2022-12-08	2023-01-24
4578	Severe Storm(s)	2021-01-12	8	Utah	34246	439802	172555	53511	Utah (Utah Division of Emergency Management)	491	Salt Lake County	49035	422306.6	422306.6	A	Public ROW	Vegetative Debris	NA	9554.0000	Cubic Yard	2020-09-08	2020-10-26
4655	Severe Storm(s)	2022-06-16	8	Montana	41490	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	30363.1000	Cubic Yard	2023-07-15	2023-09-30
4655	Severe Storm(s)	2022-06-16	8	Montana	41501	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	2755.2000	Cubic Yard	2023-04-10	2023-06-30
4655	Severe Storm(s)	2022-06-16	8	Montana	41481	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	5023.2000	Cubic Yard	2023-05-19	2023-06-23
4655	Severe Storm(s)	2022-06-16	8	Montana	41503	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	3651.0000	Cubic Yard	2023-04-25	2023-05-01
4655	Severe Storm(s)	2022-06-16	8	Montana	41476	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	2062.9000	Cubic Yard	2023-05-01	2023-06-22
4655	Severe Storm(s)	2022-06-16	8	Montana	41504	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	9049.8000	Cubic Yard	2023-05-08	2023-06-19
4655	Severe Storm(s)	2022-06-16	8	Montana	41505	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	2601.9000	Cubic Yard	2023-05-04	2023-05-07
4655	Severe Storm(s)	2022-06-16	8	Montana	41508	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	910.9000	Cubic Yard	2023-04-26	2023-06-27
4655	Severe Storm(s)	2022-06-16	8	Montana	41511	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	2090.2000	Cubic Yard	2023-05-31	2023-06-22
4655	Severe Storm(s)	2022-06-16	8	Montana	42002	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	6331.3000	Cubic Yard	2023-05-07	2023-06-30
4655	Severe Storm(s)	2022-06-16	8	Montana	41470	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	54753.8000	Cubic Yard	2023-06-06	2023-07-12
4655	Severe Storm(s)	2022-06-16	8	Montana	41473	1238782	679681	199625	Montana Disaster & Emergency Services	1709	Lewis and Clark County	30049	4623743.1	4623743.1	A	Waterway	Vegetative Debris	NA	1121.1000	Cubic Yard	2023-07-10	2023-07-10
4663	Flood	2022-07-29	4	Kentucky	44887	1248085	688836	200220	KY Division of Emergency Management	1718	Franklin County	21073	25248115.2	25248115.2	A	Public ROW	Vegetative Debris	NA	8072.9400	Cubic Yard	2022-08-04	2023-02-01
4663	Flood	2022-07-29	4	Kentucky	44664	1248084	688835	200220	KY Division of Emergency Management	1718	Franklin County	21073	20835364.4	20835364.4	A	Public Road	Vegetative Debris	NA	1305964.0000	Cubic Yard	2022-08-08	2022-09-06
4663	Flood	2022-07-29	4	Kentucky	44405	1248091	688844	200220	KY Division of Emergency Management	1718	Franklin County	21073	11305017.6	11305017.6	A	Waterway	Vegetative Debris	NA	315639.3600	Cubic Yard	2022-08-08	2022-09-06
4476	Tornado	2020-03-05	4	Tennessee	33378	377703	136382	21710	Tennessee Department of Military/TEMA	265	Davidson County	47037	614317.3	614317.3	A	Public Road	Vegetative Debris		3131.0000	Cubic Yard	2020-03-03	2020-03-29
4557	Severe Storm(s)	2020-08-17	7	Iowa	32324	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	4000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32323	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	9000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32325	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	7000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32322	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	2800.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32321	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	7000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32326	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	22600.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32320	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	1100.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32327	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	20400.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32318	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	3000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32317	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	8000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32316	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	9500.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32315	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	3000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32314	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	20000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32328	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	1000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32313	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	17000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32330	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	3500.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32312	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	25000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	33386	418197	161938	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	5056100.1	5056100.1	A	Other Public Property	Vegetative Debris	NA	1346068.0000	Cubic Yard	2020-09-21	2020-12-21
4557	Severe Storm(s)	2020-08-17	7	Iowa	33003	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	500.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32329	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	9000.0000	Cubic Yard	NA	NA
4557	Severe Storm(s)	2020-08-17	7	Iowa	32311	405187	155915	48341	Iowa Department of Homeland Security and Emergency Management	451	Polk County	19153	3443899.9	3443899.9	A	Other Public Property	Vegetative Debris	NA	1500.0000	Cubic Yard	NA	NA

1.2 Veg-Debris

1.2.1 The Vegetative Debris Data

Disaster_num	FIPS	Dec_Date	Num_Removals	Num_Damages	Num_Projects	Gross_Cost	Net_Cost	Quantity	year	Population	Infrastructure_Value	RISK_SCORE	RESL_SCORE	disasterName	incidentType	region
4284	13021	2016-10-09	1	1	1	59753.43	59753.43	0.00	2016	157280	31029231200	76.42380	65.85	HURRICANE MATTHEW	Hurricane	4
4284	13025	2016-10-09	4	4	4	242878.98	242878.98	59825.00	2016	17976	2506510997	57.46102	24.76	HURRICANE MATTHEW	Hurricane	4
4284	13029	2016-10-09	370	10	9	1232186.75	1232186.75	156564.45	2016	44426	6670531454	87.52784	78.64	HURRICANE MATTHEW	Hurricane	4
4284	13031	2016-10-09	12	9	9	2055807.22	1716018.52	176455.11	2016	80942	14170658859	89.21413	47.96	HURRICANE MATTHEW	Hurricane	4
4284	13039	2016-10-09	10	10	8	525855.78	525855.78	6462364.82	2016	54619	8633305371	85.30067	57.57	HURRICANE MATTHEW	Hurricane	4
4284	13043	2016-10-09	5	5	5	137094.82	137094.82	2038.40	2016	10953	1814850368	40.18454	5.54	HURRICANE MATTHEW	Hurricane	4
4284	13051	2016-10-09	59	48	29	94891483.38	48112145.72	1941658.36	2016	293520	56341879834	98.66370	90.77	HURRICANE MATTHEW	Hurricane	4
4284	13103	2016-10-09	13	13	10	483461.32	483461.32	18393.00	2016	64648	9810531158	79.16004	62.13	HURRICANE MATTHEW	Hurricane	4
4284	13109	2016-10-09	6	6	6	311933.31	311933.31	49181.00	2016	10729	2224696592	63.85619	29.09	HURRICANE MATTHEW	Hurricane	4
4284	13121	2016-10-09	5	5	5	5540903.00	5540903.00	210105.62	2016	1065539	231755056791	92.30035	55.28	HURRICANE MATTHEW	Hurricane	4
4284	13127	2016-10-09	30	12	12	17031721.60	11648106.88	675247.55	2016	84424	16154990642	90.80496	83.99	HURRICANE MATTHEW	Hurricane	4
4284	13165	2016-10-09	2	2	2	21963.86	21963.86	207.44	2016	8650	1504153897	28.57143	11.04	HURRICANE MATTHEW	Hurricane	4
4284	13179	2016-10-09	8	8	8	2412210.84	2412210.84	315013.07	2016	65134	12052551996	94.11390	50.48	HURRICANE MATTHEW	Hurricane	4
4284	13183	2016-10-09	4	4	4	212102.25	212102.25	7388.50	2016	16069	1885031282	56.47471	6.91	HURRICANE MATTHEW	Hurricane	4
4284	13191	2016-10-09	4	4	4	1789692.63	1789692.63	80688.62	2016	10934	2539384376	79.28731	45.93	HURRICANE MATTHEW	Hurricane	4
4284	13229	2016-10-09	5	5	5	134919.75	134919.75	7012.72	2016	19713	3511888999	70.15590	39.24	HURRICANE MATTHEW	Hurricane	4
4284	13247	2016-10-09	101	2	2	19160893.85	1980813.65	173142.70	2016	93392	17184906899	63.88801	44.08	HURRICANE MATTHEW	Hurricane	4
4284	13251	2016-10-09	4	4	4	204294.87	204294.87	101575.00	2016	13974	2746722077	67.99236	29.54	HURRICANE MATTHEW	Hurricane	4
4284	13267	2016-10-09	11	5	5	1660602.41	916350.53	140426.00	2016	22744	4622910204	83.32803	11.81	HURRICANE MATTHEW	Hurricane	4
4284	13277	2016-10-09	1	1	1	0.00	0.00	6479.00	2016	41296	10042961707	73.84664	42.58	HURRICANE MATTHEW	Hurricane	4

1.2.2 Distribution of Costs per Cubic Yard

##     Min.  1st Qu.   Median     Mean  3rd Qu.     Max. 
##     3.58    19.70    27.09   236.10    43.93 80868.80

Minimum, Central Tendency and Quartile Points. Median Cost is at $27.09 dollars. The Mean is skewed by extremely high cost projects. This is also why we log (exponentially) scale quantity and cost in most of the analysis.

Histogram showing the frequency of projects around certain cost per cubic yards. Region 4 looks very similar to the others.

1.2.2.1 Chart of Cost against Quantity

Notes: - This is on log-log scales, so major tick lines increase by powers of 10: - This allows us to again confirm that Region 4 is similar to other regions. - We can start to see an approximately linear relationship between cost and quantity. - There are some outliers we need to remove: - Low values for Cost/Quantity (probably incorrect info, or not entered info)

1.2.2.2 Chart with Regression and Line Relationships

Quite the chart! First, R4 is not separated out (it would be too confusing and we don’t need to anyway). - What I find interesting here, is the evidence for a changing relationship between Cost and Quantity. - If we use a multiplier like \(25 (1 CY of debris cost 25)\) we would have a single straight line, but it wouldn’t fit well at the beginning or end of the chart.

• The line that fits on this chart (green line) is actually a log-log line assuming an equal scaling relationship (slope =1) between the variables. This is actually a scaling relationship that looks straight because we transformed Cost and Quantity with a log10 function. -I adjusted the intercept (“base cost”) of where the line starts to make it fit close to the scattered data cloud.
• Note: the Orange line will be used to filter out the extremely large debris removal amounts.

One more chart: - The blue line is a regression relationship. - The long green line is one that I fit “by eye”.

1.2.3 Fitting a Regression Line

• The previous lines were fit “by eye”.
• We can use regression to find slope and intercept for the relationship.

veg_model <- 
veg_pred %>% 
  filter(Quantity > 10,
         Quantity < 1e07,
         Gross_Cost > 500,
         Gross_Cost < 3.1e09) %>% 
  lm(formula = log10(Gross_Cost) ~ log10(Quantity))

summary(veg_model)

## 
## Call:
## lm(formula = log10(Gross_Cost) ~ log10(Quantity), data = .)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -3.5159 -0.3614 -0.0335  0.3361  2.7097 
## 
## Coefficients:
##                 Estimate Std. Error t value Pr(>|t|)    
## (Intercept)      2.58276    0.04412   58.55   <2e-16 ***
## log10(Quantity)  0.73076    0.01148   63.64   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.6577 on 2401 degrees of freedom
## Multiple R-squared:  0.6278, Adjusted R-squared:  0.6277 
## F-statistic:  4051 on 1 and 2401 DF,  p-value: < 2.2e-16

The model is significant, with a reasonable R^2 fit. We can then turn this model into a formula using the slope intercept transformation of the regression coefficients. Note: these are log(10) transformed, but the function below puts a given quantity back to a dollar amount.

veg_reg_formula <- function(Quantity){
  10^(log10(Quantity)*.73076 + 2.58276)
}

1.2.3.1 Example

dollar(veg_reg_formula(1000))

## [1] "$59,571.70"

1.2.3.2 Formula Explained

• Slope intercept formula converted to log-log format is:
• \(log10(Cost) = intercept + slope * log10(Quantity)\)
• \(log10(Cost) ~= 2.583 + .731 * log10(1000)\)
• \(59,571.70 = 2.583 + .731 * 3\)

Comparing this to the $25 per CY, where we have - \(1000*25 - 25,000\)

We can build a comparison of the model based formula v. other formulas later. There is also a possibility of adding in further correlated variables as predictors to the model formula, such as: - average (historical) project cost per county - infrastructure value per county, population per county.

1.2.3.3 Correlated Predictors (For Possible Future Iterations)

• Not many promising predictors at the moment…

#glimpse(veg_pred.m)

cor.test(veg_pred.m$Gross_Cost, veg_pred.m$Quantity, method = "spearman")

## 
##  Spearman's rank correlation rho
## 
## data:  veg_pred.m$Gross_Cost and veg_pred.m$Quantity
## S = 446435302, p-value < 2.2e-16
## alternative hypothesis: true rho is not equal to 0
## sample estimates:
##       rho 
## 0.7568245

#rho=.75  #rank oreder corr

cor.test(log10(veg_pred.m$Gross_Cost), log10(veg_pred.m$Quantity))

## 
##  Pearson's product-moment correlation
## 
## data:  log10(veg_pred.m$Gross_Cost) and log10(veg_pred.m$Quantity)
## t = 49.936, df = 2223, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.7069106 0.7461177
## sample estimates:
##       cor 
## 0.7271065

#r = .73
mean(veg_pred.m$Quantity)

## [1] 2064069

cor.test(scale(as.numeric(veg_pred.m$Population)), log(veg_pred.m$Quantity))

## 
##  Pearson's product-moment correlation
## 
## data:  scale(as.numeric(veg_pred.m$Population)) and log(veg_pred.m$Quantity)
## t = 4.8078, df = 2223, p-value = 1.628e-06
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.06014428 0.14240093
## sample estimates:
##      cor 
## 0.101446

cor.test(veg_pred$RESL_SCORE, log(1+veg_pred$Quantity))

## 
##  Pearson's product-moment correlation
## 
## data:  veg_pred$RESL_SCORE and log(1 + veg_pred$Quantity)
## t = 1.1465, df = 2375, p-value = 0.2517
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  -0.01670020  0.06366419
## sample estimates:
##     cor 
## 0.02352

1.3 Const-Debris

1.3.1 The Data:

Here is the Grants Manager data for construction debris removals, again aggregated to county level removals. If there are multiple projects sites for a removal, they are gathered up so each row representes a given Cat Work A - Sum of Quantity Removed and Sum of Cost of removal.

Disaster_num	FIPS	Dec_Date	Num_Removals	Num_Damages	Num_Projects	Gross_Cost	Net_Cost	Quantity	year	Population	Infrastructure_Value	RISK_SCORE	RESL_SCORE	disasterName	incidentType	region
4284	13051	2016-10-09	2	2	2	3.705885e+06	3705885.12	5.040000e+02	2016	293520	5.634188e+10	98.6636971	90.77	HURRICANE MATTHEW	Hurricane	4
4344	06067	2017-10-10	2	2	2	2.887155e+06	2887155.27	1.579100e+04	2017	1584652	2.637269e+11	97.6455616	65.53	WILDFIRES	Fire	9
4344	06097	2017-10-10	1	1	1	4.068530e+03	4068.53	2.000000e+00	2017	488330	1.046105e+11	99.1727649	72.98	WILDFIRES	Fire	9
4337	12001	2017-09-10	5	2	2	5.910707e+06	3027397.24	1.429740e+04	2017	277984	4.273670e+10	93.8275533	74.44	HURRICANE IRMA	Hurricane	4
4337	12007	2017-09-10	1	1	1	5.966274e+04	59662.74	1.400000e+02	2017	28233	3.560269e+09	70.2195355	28.39	HURRICANE IRMA	Hurricane	4
4337	12009	2017-09-10	10	10	10	3.529646e+06	3529646.08	1.135205e+05	2017	606067	1.055946e+11	99.3636653	59.83	HURRICANE IRMA	Hurricane	4
4337	12011	2017-09-10	16	16	16	2.210745e+07	22107450.30	4.353217e+05	2017	1940829	2.681728e+11	99.7454661	44.84	HURRICANE IRMA	Hurricane	4
4337	12019	2017-09-10	8	5	5	8.039765e+06	7292302.87	1.303454e+05	2017	218078	2.936411e+10	88.7686923	57.67	HURRICANE IRMA	Hurricane	4
4337	12021	2017-09-10	6	3	3	6.718732e+05	569055.77	2.136282e+05	2017	375443	8.254240e+10	98.8545975	20.15	HURRICANE IRMA	Hurricane	4
4337	12027	2017-09-10	6	6	4	1.437593e+06	1437593.03	1.647947e+05	2017	33898	5.358888e+09	90.4231626	1.11	HURRICANE IRMA	Hurricane	4
4337	12031	2017-09-10	7	7	7	1.364659e+06	1364659.15	2.211878e+05	2017	994675	1.584862e+11	97.8364620	67.19	HURRICANE IRMA	Hurricane	4
4337	12035	2017-09-10	7	7	7	1.707548e+06	1707547.73	4.198133e+04	2017	115270	1.705646e+10	88.3550748	33.13	HURRICANE IRMA	Hurricane	4
4337	12043	2017-09-10	1	1	1	5.911640e+03	5911.64	5.667340e+04	2017	12052	2.247458e+09	74.9920458	0.70	HURRICANE IRMA	Hurricane	4
4337	12051	2017-09-10	1	1	1	4.305388e+05	430538.76	4.670000e+02	2017	39371	6.080710e+09	91.1549475	0.89	HURRICANE IRMA	Hurricane	4
4337	12055	2017-09-10	2	2	2	1.340932e+07	13409317.59	5.263260e+04	2017	101136	1.753236e+10	90.2958956	4.81	HURRICANE IRMA	Hurricane	4
4337	12057	2017-09-10	1	1	1	4.834040e+03	4834.04	2.200000e+03	2017	1458282	2.038126e+11	99.5545657	40.90	HURRICANE IRMA	Hurricane	4
4337	12061	2017-09-10	2	2	2	3.078071e+05	307807.07	4.844200e+02	2017	159719	2.862201e+10	97.0728603	49.55	HURRICANE IRMA	Hurricane	4
4337	12069	2017-09-10	2	2	2	6.367834e+06	6367834.33	4.258000e+03	2017	383042	5.896930e+10	95.2274897	48.09	HURRICANE IRMA	Hurricane	4
4337	12071	2017-09-10	9	9	8	1.992298e+07	19922980.08	3.560657e+04	2017	759922	1.233084e+11	99.4909322	9.17	HURRICANE IRMA	Hurricane	4
4337	12073	2017-09-10	9	9	9	3.198412e+07	31984115.95	1.301668e+05	2017	292157	4.688315e+10	94.5593382	74.76	HURRICANE IRMA	Hurricane	4
4337	12081	2017-09-10	3	3	3	1.173623e+07	11736228.42	8.925600e+03	2017	399485	6.672028e+10	98.4409800	23.90	HURRICANE IRMA	Hurricane	4
4337	12083	2017-09-10	4	1	1	1.118972e+05	55948.60	1.316000e+02	2017	375566	5.623256e+10	96.2456252	20.05	HURRICANE IRMA	Hurricane	4
4337	12086	2017-09-10	28	25	24	2.112189e+07	21082923.83	1.263430e+06	2017	2698679	3.195744e+11	99.8090996	37.11	HURRICANE IRMA	Hurricane	4
4337	12087	2017-09-10	17	14	13	6.142769e+07	46879999.20	8.578856e+05	2017	82390	1.808080e+10	95.9274578	27.88	HURRICANE IRMA	Hurricane	4
4337	12089	2017-09-10	2	2	2	3.162066e+06	3162065.57	2.345950e+03	2017	90123	1.418695e+10	83.0734967	70.78	HURRICANE IRMA	Hurricane	4
4337	12093	2017-09-10	2	2	2	1.699323e+06	1699323.41	1.455700e+03	2017	39455	6.060952e+09	87.5914731	2.42	HURRICANE IRMA	Hurricane	4
4337	12095	2017-09-10	2	2	2	4.278189e+05	427818.87	4.963960e+03	2017	1428790	2.324704e+11	98.5682469	43.92	HURRICANE IRMA	Hurricane	4
4337	12097	2017-09-10	3	3	3	3.820086e+05	382008.61	1.861718e+04	2017	387795	5.045786e+10	95.1320395	35.74	HURRICANE IRMA	Hurricane	4
4337	12099	2017-09-10	8	8	8	2.098244e+06	2098244.25	1.612295e+04	2017	1489461	2.385678e+11	99.7136494	23.65	HURRICANE IRMA	Hurricane	4
4337	12101	2017-09-10	1	1	1	1.484174e+04	14841.74	2.000000e+00	2017	561566	8.980181e+10	99.0454979	13.21	HURRICANE IRMA	Hurricane	4
4337	12103	2017-09-10	16	13	13	2.622531e+07	14089979.61	1.243350e+06	2017	958822	1.452981e+11	99.2045816	12.00	HURRICANE IRMA	Hurricane	4
4337	12105	2017-09-10	4	4	4	1.379514e+07	13795142.37	6.649810e+05	2017	721918	1.007445e+11	98.0273624	30.36	HURRICANE IRMA	Hurricane	4
4337	12107	2017-09-10	2	2	2	3.211588e+06	3211587.80	3.044940e+04	2017	73208	1.125835e+10	90.1686287	14.23	HURRICANE IRMA	Hurricane	4
4337	12109	2017-09-10	16	5	5	1.758281e+06	1524340.54	1.446476e+04	2017	273175	5.135085e+10	94.1457206	81.99	HURRICANE IRMA	Hurricane	4
4337	12115	2017-09-10	1	1	1	6.948444e+04	69484.44	2.750000e+01	2017	433908	8.064207e+10	98.4091632	9.23	HURRICANE IRMA	Hurricane	4
4337	12117	2017-09-10	7	4	4	1.372560e+06	1081807.04	1.974345e+04	2017	470586	7.253923e+10	95.6411072	64.58	HURRICANE IRMA	Hurricane	4
4337	12127	2017-09-10	12	12	12	1.472103e+07	14721033.87	9.080085e+04	2017	551829	8.247022e+10	97.5182946	45.64	HURRICANE IRMA	Hurricane	4
4338	13039	2017-09-16	4	4	4	1.249740e+06	1249740.45	5.001874e+06	2017	54619	8.633305e+09	85.3006682	57.57	HURRICANE IRMA	Hurricane	4
4297	13081	2017-01-26	2	2	2	2.829343e+04	28293.43	5.210000e+01	2017	20073	4.970131e+09	61.1199491	20.75	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4294	13095	2017-01-25	2	2	2	7.084616e+06	7084615.96	1.281275e+04	2017	85747	1.924929e+10	79.5100223	54.68	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Severe Storm	4
4297	13095	2017-01-26	4677	17	3	4.188572e+08	21196961.65	1.196095e+06	2017	85747	1.924929e+10	79.5100223	54.68	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4338	13127	2017-09-16	3	3	3	7.850670e+06	7850670.10	6.964770e+03	2017	84424	1.615499e+10	90.8049634	83.99	HURRICANE IRMA	Hurricane	4
4350	28047	2017-11-23	1	1	1	2.444791e+04	24447.91	7.190000e+01	2017	208275	3.732934e+10	97.2001273	67.41	HURRICANE NATE	Hurricane	4
4317	29051	2017-06-02	3	3	2	3.968734e+04	39687.34	1.950000e+02	2017	76989	1.757678e+10	74.6102450	90.67	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING	Flood	7
4317	29091	2017-06-02	4	1	1	1.737840e+05	86892.00	1.100000e+02	2017	39672	1.001590e+10	81.7690105	12.09	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING	Flood	7
4317	29099	2017-06-02	1	1	1	3.309160e+03	3309.16	1.754891e+05	2017	226703	3.437278e+10	87.2096723	74.86	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING	Flood	7
4317	29149	2017-06-02	3	3	3	1.666061e+05	166606.08	1.323305e+05	2017	8635	2.416828e+09	51.9885460	0.76	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING	Flood	7
4317	29189	2017-06-02	1	1	1	1.446020e+03	1446.02	8.000000e+01	2017	1003734	2.351181e+11	98.5364302	77.66	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING	Flood	7
4329	33009	2017-08-09	1	1	1	3.709950e+03	3709.95	2.220000e+00	2017	91072	2.025017e+10	66.4015272	66.36	SEVERE STORMS AND FLOODING	Severe Storm	1
4346	45013	2017-10-16	1	1	1	2.853906e+05	285390.56	8.880000e+02	2017	186606	4.113781e+10	98.3455297	64.10	HURRICANE IRMA	Hurricane	4
4346	45019	2017-10-16	4	4	4	2.399184e+06	2399183.76	3.465800e+03	2017	407722	8.599560e+10	99.4591155	92.71	HURRICANE IRMA	Hurricane	4
4332	48007	2017-08-25	4	4	4	2.847465e+06	2847465.32	1.187878e+05	2017	23703	5.141210e+09	84.5052498	46.34	HURRICANE HARVEY	Hurricane	6
4332	48039	2017-08-25	9	6	5	8.219233e+06	8191287.35	1.750138e+05	2017	371474	5.751482e+10	99.1091314	71.71	HURRICANE HARVEY	Hurricane	6
4332	48057	2017-08-25	1	1	1	3.777138e+05	377713.75	6.056420e+05	2017	20057	4.802417e+09	85.1415845	75.43	HURRICANE HARVEY	Hurricane	6
4332	48071	2017-08-25	1	1	1	1.157696e+05	115769.57	5.000000e+03	2017	46507	1.201820e+10	89.7550111	91.88	HURRICANE HARVEY	Hurricane	6
4332	48089	2017-08-25	1	1	1	1.358339e+05	135833.94	1.558000e+04	2017	20532	6.709205e+09	69.4877506	45.07	HURRICANE HARVEY	Hurricane	6
4332	48091	2017-08-25	1	1	1	3.217175e+04	32171.75	1.720000e+01	2017	161300	3.132962e+10	90.3595291	76.35	HURRICANE HARVEY	Hurricane	6
4332	48157	2017-08-25	3	3	3	2.123830e+05	212382.96	3.083200e+03	2017	822581	1.389588e+11	99.0773147	56.43	HURRICANE HARVEY	Hurricane	6
4332	48167	2017-08-25	11	8	8	2.563490e+07	15840931.97	7.932393e+05	2017	350477	5.674698e+10	99.5227490	90.36	HURRICANE HARVEY	Hurricane	6
4332	48199	2017-08-25	5	5	5	7.272911e+05	727291.13	7.928390e+04	2017	56129	1.037468e+10	83.8052816	46.50	HURRICANE HARVEY	Hurricane	6
4332	48201	2017-08-25	20	20	20	4.383438e+07	43834377.28	1.439547e+06	2017	4726200	7.472565e+11	99.9681833	12.73	HURRICANE HARVEY	Hurricane	6
4332	48239	2017-08-25	1	1	1	6.656425e+04	66564.25	7.638000e+03	2017	14955	6.581488e+09	88.0369074	38.03	HURRICANE HARVEY	Hurricane	6
4332	48245	2017-08-25	9	6	6	1.557740e+07	15568113.41	1.105035e+06	2017	256386	3.854901e+10	97.7410118	68.01	HURRICANE HARVEY	Hurricane	6
4332	48287	2017-08-25	1	1	1	6.533230e+03	6533.23	2.700000e+02	2017	17463	3.773540e+09	38.9436844	40.67	HURRICANE HARVEY	Hurricane	6
4332	48291	2017-08-25	2	2	2	4.152299e+04	41522.99	1.603400e+03	2017	91492	1.026688e+10	91.6321985	25.53	HURRICANE HARVEY	Hurricane	6
4332	48321	2017-08-25	3	3	3	3.178575e+05	317857.49	3.274200e+03	2017	36214	6.666911e+09	89.7868279	44.97	HURRICANE HARVEY	Hurricane	6
4332	48339	2017-08-25	3	3	3	2.221158e+05	222115.80	3.736000e+03	2017	620016	9.583079e+10	96.7228762	38.57	HURRICANE HARVEY	Hurricane	6
4332	48351	2017-08-25	1	1	1	1.996190e+05	199618.97	8.824000e+03	2017	12151	2.050022e+09	47.8205536	3.72	HURRICANE HARVEY	Hurricane	6
4332	48355	2017-08-25	13	5	5	1.273601e+08	43605609.19	1.611233e+06	2017	352623	5.585192e+10	97.5501114	76.70	HURRICANE HARVEY	Hurricane	6
4332	48361	2017-08-25	18	6	6	5.844348e+07	29451483.35	1.711566e+06	2017	84645	1.477127e+10	96.5637926	63.75	HURRICANE HARVEY	Hurricane	6
4332	48373	2017-08-25	1	1	1	6.586066e+04	65860.66	3.271700e+03	2017	49569	7.639450e+09	82.2144448	18.08	HURRICANE HARVEY	Hurricane	6
4332	48391	2017-08-25	1	1	1	1.233052e+05	17939.78	7.000000e+01	2017	6741	1.518277e+09	63.5062043	33.45	HURRICANE HARVEY	Hurricane	6
4332	48407	2017-08-25	1	1	1	1.192560e+04	11925.60	8.800000e+02	2017	27373	4.114451e+09	76.3919822	8.88	HURRICANE HARVEY	Hurricane	6
4332	48409	2017-08-25	24	6	6	1.018784e+08	36331134.66	1.297303e+06	2017	68653	1.095620e+10	89.1504932	46.56	HURRICANE HARVEY	Hurricane	6
4332	48453	2017-08-25	8	5	4	2.087443e+07	18494026.05	6.116253e+06	2017	1285769	1.895386e+11	96.8819599	56.75	HURRICANE HARVEY	Hurricane	6
4332	48469	2017-08-25	1	1	1	7.734620e+06	7734619.61	2.371645e+04	2017	91218	1.636339e+10	91.9503659	47.14	HURRICANE HARVEY	Hurricane	6
4332	48471	2017-08-25	1	1	1	1.318225e+04	13182.25	2.692136e+06	2017	76299	1.014816e+10	80.4963411	19.29	HURRICANE HARVEY	Hurricane	6
4332	48473	2017-08-25	1	1	1	8.076687e+04	80766.87	1.158000e+03	2017	56764	1.240359e+10	79.7645562	36.89	HURRICANE HARVEY	Hurricane	6
4332	48481	2017-08-25	6	3	2	4.031395e+06	2056091.56	1.860052e+05	2017	41544	8.099223e+09	89.8822781	44.53	HURRICANE HARVEY	Hurricane	6
4343	55023	2017-10-07	1	1	1	2.067520e+03	2067.52	2.000000e+01	2017	16088	7.987750e+09	66.1151766	72.69	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD	Severe Storm	5
4343	55043	2017-10-07	1	1	1	2.295321e+04	22953.21	1.972746e+01	2017	51299	1.162080e+10	61.7562838	68.87	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD	Severe Storm	5
4343	55123	2017-10-07	1	1	1	5.471690e+03	5471.69	1.200000e+02	2017	30574	7.252761e+09	51.1294941	73.93	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD	Severe Storm	5
4339	72003	2017-09-20	1	1	1	1.117674e+07	11176744.73	2.311582e+04	2017	38125	4.957845e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72013	2017-09-20	2	2	2	8.100000e+03	8100.00	1.598148e+02	2017	87581	1.190678e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72021	2017-09-20	2	2	2	1.808207e+04	18082.07	1.230600e+02	2017	184904	2.888948e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72027	2017-09-20	1	1	1	6.301887e+05	630188.73	1.266960e+04	2017	32797	3.642558e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72031	2017-09-20	7	4	4	6.085016e+05	480450.04	5.396000e+03	2017	154696	2.283049e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72045	2017-09-20	1	1	1	1.115410e+05	111541.00	1.800000e+02	2017	18883	1.969412e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72051	2017-09-20	1	1	1	7.457270e+03	7457.27	3.500000e+01	2017	35792	4.913842e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72057	2017-09-20	1	1	1	4.091200e+03	4091.20	2.280000e+02	2017	36538	5.954075e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72061	2017-09-20	1	1	1	4.304567e+06	4304566.52	1.441217e+04	2017	89604	1.653781e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72065	2017-09-20	2	2	2	1.216378e+05	109558.38	1.737360e+03	2017	38444	4.799716e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72075	2017-09-20	1	1	1	2.799388e+04	27993.88	7.000000e+01	2017	46316	4.988138e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4336	72077	2017-09-10	2	2	2	1.529488e+05	152948.79	2.349000e+03	2017	36808	4.359239e+09	NA	NA	HURRICANE IRMA	Hurricane	2
4339	72077	2017-09-20	1	1	1	4.255565e+06	4255565.09	7.867000e+03	2017	36808	4.359239e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72085	2017-09-20	2	2	2	6.081998e+06	6081997.93	1.123299e+05	2017	35117	4.852675e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72093	2017-09-20	1	1	1	3.902432e+06	3902432.07	4.015700e+03	2017	4733	5.949854e+08	NA	NA	HURRICANE MARIA	Hurricane	2
4336	72103	2017-09-10	2	2	2	2.336348e+05	233634.78	1.237900e+03	2017	23283	2.953017e+09	NA	NA	HURRICANE IRMA	Hurricane	2
4339	72103	2017-09-20	1	1	1	2.970000e+04	29700.00	3.500000e+02	2017	23283	2.953017e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72105	2017-09-20	2	2	2	1.434530e+06	1434529.99	3.230785e+04	2017	29241	2.934399e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72109	2017-09-20	1	1	1	2.668247e+05	266824.67	5.347060e+03	2017	15929	2.009534e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72111	2017-09-20	2	2	2	1.212950e+06	1212950.30	9.680060e+02	2017	20320	2.518446e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72113	2017-09-20	3	3	3	7.292549e+05	729254.89	2.246476e+05	2017	137316	2.102578e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72117	2017-09-20	1	1	1	7.947540e+04	79475.40	1.572450e+03	2017	15187	2.056385e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72123	2017-09-20	1	1	1	6.136379e+05	613637.94	7.337740e+03	2017	25742	3.835226e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72127	2017-09-20	71	12	12	5.094905e+08	94516937.40	1.429344e+05	2017	341981	6.618328e+10	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72135	2017-09-20	1	1	1	8.427339e+06	8427338.70	4.862000e+03	2017	66827	6.691613e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72151	2017-09-20	1	1	1	1.692698e+06	1692698.04	2.060524e+04	2017	30397	3.345120e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4339	72153	2017-09-20	1	1	1	6.313312e+05	631331.25	5.279580e+03	2017	34151	3.045488e+09	NA	NA	HURRICANE MARIA	Hurricane	2
4362	01015	2018-04-26	5	5	5	5.949913e+06	5949913.22	1.064080e+06	2018	116250	2.269150e+10	84.3779828	46.72	SEVERE STORMS AND TORNADOES	Severe Storm	4
4362	01055	2018-04-26	1	1	1	3.005575e+05	300557.48	2.800000e+04	2018	103320	1.900045e+10	82.2462615	53.66	SEVERE STORMS AND TORNADOES	Severe Storm	4
4406	01069	2018-11-05	2	2	2	5.046204e+06	5046204.31	7.605860e+03	2018	107125	2.376142e+10	90.6776965	64.00	HURRICANE MICHAEL	Hurricane	4
4362	01115	2018-04-26	1	1	1	3.067902e+05	306790.20	3.200000e+02	2018	90899	1.311334e+10	70.7922367	48.50	SEVERE STORMS AND TORNADOES	Severe Storm	4
4407	06007	2018-11-12	3	3	3	5.845413e+05	455216.28	2.499960e+05	2018	211490	4.251521e+10	97.1683105	62.41	WILDFIRES	Fire	9
4407	06037	2018-11-12	2	2	2	1.856366e+05	185636.61	4.628601e+01	2018	10005712	1.517716e+12	100.0000000	19.67	WILDFIRES	Fire	9
4382	06067	2018-08-05	1	1	1	6.605000e+07	66050000.00	9.840000e+02	2018	1584652	2.637269e+11	97.6455616	65.53	WILDFIRES AND HIGH WINDS	Fire	9
4407	06067	2018-11-12	1	1	1	2.380376e+07	23803762.44	2.871600e+04	2018	1584652	2.637269e+11	97.6455616	65.53	WILDFIRES	Fire	9
4353	06083	2018-01-03	4	4	2	5.495064e+06	5495064.48	1.773000e+03	2018	447998	7.845353e+10	99.3954820	47.93	WILDFIRES, FLOODING, MUDFLOWS, AND DEBRIS FLOWS	Fire	9
4382	06089	2018-08-05	2	2	2	7.360249e+04	73602.49	0.000000e+00	2018	181918	3.728918e+10	95.2911231	50.95	WILDFIRES AND HIGH WINDS	Fire	9
4353	06111	2018-01-03	1	1	1	5.917860e+05	591786.03	6.000000e+00	2018	843136	1.513737e+11	99.4272988	47.04	WILDFIRES, FLOODING, MUDFLOWS, AND DEBRIS FLOWS	Fire	9
4407	06111	2018-11-12	1	1	1	2.299776e+05	229977.60	3.635760e+04	2018	843136	1.513737e+11	99.4272988	47.04	WILDFIRES	Fire	9
4399	12005	2018-10-11	666	25	25	1.219259e+09	422451597.80	7.065869e+06	2018	174869	3.231735e+10	97.4864779	31.41	HURRICANE MICHAEL	Hurricane	4
4399	12013	2018-10-11	2	2	2	3.520674e+05	352067.43	2.986000e+03	2018	13597	2.454658e+09	68.5332485	13.34	HURRICANE MICHAEL	Hurricane	4
4399	12037	2018-10-11	2	2	2	1.163034e+05	116303.39	4.480000e+04	2018	12426	2.829817e+09	70.6649698	28.55	HURRICANE MICHAEL	Hurricane	4
4399	12039	2018-10-11	1	1	1	1.011368e+04	10113.68	1.092592e+04	2018	43693	6.497843e+09	80.0509068	32.88	HURRICANE MICHAEL	Hurricane	4
4399	12045	2018-10-11	2	2	2	1.264253e+06	1264253.34	2.760000e+03	2018	14176	2.743053e+09	76.2647152	43.22	HURRICANE MICHAEL	Hurricane	4
4399	12063	2018-10-11	1	1	1	1.075691e+07	10756905.86	4.307620e+05	2018	47249	8.012107e+09	85.8097359	20.91	HURRICANE MICHAEL	Hurricane	4
4399	12073	2018-10-11	116	17	17	3.972479e+08	267038661.18	1.437230e+06	2018	292157	4.688315e+10	94.5593382	74.76	HURRICANE MICHAEL	Hurricane	4
4399	12123	2018-10-11	1	1	1	7.833412e+04	78334.12	2.053206e+05	2018	21690	3.630806e+09	74.0057270	16.17	HURRICANE MICHAEL	Hurricane	4
4399	12133	2018-10-11	1	1	1	0.000000e+00	0.00	9.500000e+01	2018	25288	3.660356e+09	87.7187401	15.60	HURRICANE MICHAEL	Hurricane	4
4400	13081	2018-10-14	1	1	1	2.558951e+05	255895.10	6.533300e+03	2018	20073	4.970131e+09	61.1199491	20.75	HURRICANE MICHAEL	Hurricane	4
4400	13087	2018-10-14	1	1	1	6.251782e+06	6251782.29	1.231300e+02	2018	29305	5.487419e+09	80.7826917	18.36	HURRICANE MICHAEL	Hurricane	4
4400	13095	2018-10-14	3	3	3	7.658757e+06	7658757.34	4.982200e+03	2018	85747	1.924929e+10	79.5100223	54.68	HURRICANE MICHAEL	Hurricane	4
4400	13099	2018-10-14	1	1	1	2.034805e+05	203480.51	2.000000e+05	2018	10781	2.629068e+09	59.4018454	29.06	HURRICANE MICHAEL	Hurricane	4
4400	13121	2018-10-14	1	1	1	3.407570e+03	3407.57	5.000000e+00	2018	1065539	2.317551e+11	92.3003500	55.28	HURRICANE MICHAEL	Hurricane	4
4400	13201	2018-10-14	1	1	1	1.250563e+05	125056.33	7.968000e+02	2018	5989	1.442293e+09	45.5615654	25.08	HURRICANE MICHAEL	Hurricane	4
4400	13253	2018-10-14	2	2	2	2.209354e+05	220935.38	4.762900e+03	2018	9105	2.212101e+09	62.9971365	14.99	HURRICANE MICHAEL	Hurricane	4
4365	15007	2018-05-08	2	2	2	9.381912e+05	938191.17	3.730000e+02	2018	73136	1.453875e+10	74.4193446	84.85	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	9
4363	18019	2018-05-04	1	1	1	6.492410e+03	6492.41	3.000000e+02	2018	120950	2.158405e+10	81.9280942	76.16	SEVERE STORMS AND FLOODING	Flood	5
4363	18061	2018-05-04	1	1	1	3.732700e+03	3732.70	9.520000e+02	2018	39636	7.284303e+09	60.1972638	45.77	SEVERE STORMS AND FLOODING	Flood	5
4363	18099	2018-05-04	1	1	1	5.291750e+03	5291.75	6.130000e+02	2018	46062	1.017629e+10	42.5071588	70.59	SEVERE STORMS AND FLOODING	Flood	5
4386	19119	2018-08-20	1	1	1	6.327620e+03	6327.62	6.000000e+01	2018	11934	3.533338e+09	34.2984410	85.42	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	7
4392	19127	2018-09-12	4900	1	1	1.361042e+09	19443461.10	3.486432e+05	2018	40092	1.087537e+10	68.8514158	68.52	SEVERE STORM AND TORNADOES	Severe Storm	7
4386	19141	2018-08-20	1	1	1	2.628680e+04	26286.80	3.900000e+02	2018	14182	4.720749e+09	67.4196627	95.80	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	7
4386	19153	2018-08-20	4	4	4	3.565789e+05	356578.94	3.800370e+04	2018	492316	9.393685e+10	91.5367483	95.58	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	7
4392	19169	2018-09-12	1	1	1	1.682558e+05	168255.77	2.733750e+03	2018	98533	1.981740e+10	76.0101814	88.89	SEVERE STORM AND TORNADOES	Severe Storm	7
4386	19191	2018-08-20	1	1	1	8.111990e+03	8111.99	2.000000e+00	2018	20051	6.671076e+09	45.1479478	95.45	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	7
4361	21111	2018-04-26	4	1	1	1.206681e+06	603340.60	9.301000e+03	2018	782833	1.432227e+11	95.9592746	77.94	SEVERE STORMS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4376	24003	2018-07-03	1	1	1	4.318837e+04	43188.37	1.209226e+04	2018	587917	9.523544e+10	92.0139994	90.01	SEVERE STORM AND FLOODING	Flood	3
4376	24027	2018-07-03	1	1	1	3.857715e+05	385771.50	1.344000e+03	2018	332270	6.535684e+10	80.4008909	81.51	SEVERE STORM AND FLOODING	Flood	3
4372	25009	2018-06-25	1	1	1	4.569497e+04	45694.97	9.625000e+01	2018	808897	1.504420e+11	93.9548202	96.21	SEVERE WINTER STORM AND FLOODING	Severe Storm	1
4372	25021	2018-06-25	2	2	2	2.212549e+05	221254.87	2.000000e+00	2018	725648	1.489036e+11	92.9048680	93.98	SEVERE WINTER STORM AND FLOODING	Severe Storm	1
4372	25023	2018-06-25	2	2	2	3.556252e+05	355625.20	9.508000e+04	2018	530320	1.025170e+11	90.9958638	99.01	SEVERE WINTER STORM AND FLOODING	Severe Storm	1
4390	27101	2018-09-05	1	1	1	1.114522e+04	11145.22	6.930000e+02	2018	8175	2.988917e+09	30.7986001	93.79	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4390	27127	2018-09-05	2	2	2	3.963801e+04	39638.01	1.117750e+04	2018	15425	4.482224e+09	33.4393891	96.31	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4397	36001	2018-10-01	5	2	2	7.121837e+06	4507982.53	3.164186e+04	2018	314684	6.262032e+10	75.5011136	94.02	SEVERE STORMS AND FLOODING	Flood	2
4393	37013	2018-09-14	10	7	7	8.602717e+05	826351.68	9.206397e+03	2018	44607	9.451940e+09	94.4957047	55.38	HURRICANE FLORENCE	Hurricane	4
4393	37017	2018-09-14	2	2	2	1.263996e+05	126399.56	2.798560e+04	2018	29597	8.417363e+09	90.9004136	23.87	HURRICANE FLORENCE	Hurricane	4
4393	37019	2018-09-14	14	14	14	1.331598e+07	13315982.85	3.588177e+05	2018	136245	2.994477e+10	97.0410436	64.93	HURRICANE FLORENCE	Hurricane	4
4393	37031	2018-09-14	15	15	15	2.107035e+07	21070350.44	4.328141e+05	2018	67625	1.740755e+10	97.1046771	83.10	HURRICANE FLORENCE	Hurricane	4
4393	37047	2018-09-14	5	5	5	3.406568e+05	340656.77	2.375821e+05	2018	50557	8.015801e+09	91.1231308	23.11	HURRICANE FLORENCE	Hurricane	4
4393	37049	2018-09-14	15	9	9	1.337726e+07	11010303.55	8.857768e+04	2018	100042	1.736429e+10	96.4047089	65.63	HURRICANE FLORENCE	Hurricane	4
4393	37051	2018-09-14	9	6	5	1.293207e+07	8203556.23	1.304293e+05	2018	334379	5.107665e+10	92.5230671	43.54	HURRICANE FLORENCE	Hurricane	4
4393	37061	2018-09-14	3	3	3	1.489586e+05	148958.59	3.223786e+05	2018	48624	8.582202e+09	93.3821190	8.34	HURRICANE FLORENCE	Hurricane	4
4393	37103	2018-09-14	1	1	1	3.056677e+05	305667.65	3.340000e+02	2018	9165	1.485431e+09	79.9872733	20.34	HURRICANE FLORENCE	Hurricane	4
4393	37107	2018-09-14	1	1	1	9.623538e+05	962353.75	1.269900e+03	2018	55112	1.175561e+10	91.7912822	52.51	HURRICANE FLORENCE	Hurricane	4
4393	37129	2018-09-14	6	6	6	1.647612e+07	16476124.28	5.290670e+04	2018	225344	5.126031e+10	98.5046134	82.27	HURRICANE FLORENCE	Hurricane	4
4393	37133	2018-09-14	6	6	6	1.492910e+07	14929098.44	3.615121e+05	2018	202949	3.015480e+10	97.9319122	63.18	HURRICANE FLORENCE	Hurricane	4
4393	37135	2018-09-14	1	1	1	5.106464e+04	51064.64	1.284000e+03	2018	148579	2.699894e+10	72.9557747	65.05	HURRICANE FLORENCE	Hurricane	4
4393	37137	2018-09-14	4	4	4	3.062022e+06	3062021.80	3.502578e+04	2018	12213	3.222184e+09	84.7916004	61.23	HURRICANE FLORENCE	Hurricane	4
4393	37141	2018-09-14	3	3	3	1.238024e+07	12380244.98	1.804919e+05	2018	60195	1.105170e+10	94.0184537	56.87	HURRICANE FLORENCE	Hurricane	4
4393	37151	2018-09-14	1	1	1	2.812469e+04	28124.69	7.353600e+02	2018	144115	2.604142e+10	75.8510977	33.35	HURRICANE FLORENCE	Hurricane	4
4393	37155	2018-09-14	5	5	5	2.722674e+06	2705433.90	4.252400e+04	2018	116414	1.841898e+10	94.3684378	12.64	HURRICANE FLORENCE	Hurricane	4
4393	37163	2018-09-14	2	2	2	6.604271e+04	66042.71	2.400000e+02	2018	59021	1.256312e+10	93.9866370	11.55	HURRICANE FLORENCE	Hurricane	4
4393	37183	2018-09-14	8	8	8	1.247636e+07	12476355.53	2.431282e+05	2018	1128357	2.152861e+11	93.6366529	72.02	HURRICANE FLORENCE	Hurricane	4
4393	37191	2018-09-14	3	3	3	7.201412e+04	72014.12	4.823320e+03	2018	116680	2.717472e+10	94.4320713	44.11	HURRICANE FLORENCE	Hurricane	4
4360	39061	2018-04-17	1	1	1	7.130350e+03	7130.35	1.800000e+02	2018	830623	1.538887e+11	93.4457525	86.31	SEVERE STORMS, LANDSLIDES, AND MUDSLIDES	Flood	5
4408	42015	2018-11-27	1	1	1	3.639055e+04	36390.55	1.970060e+04	2018	59840	1.440289e+10	71.5240216	64.96	SEVERE STORMS AND FLOODING	Severe Storm	3
4408	42037	2018-11-27	1	1	1	4.833000e+03	4833.00	1.464000e+03	2018	64676	1.272554e+10	36.3665288	86.03	SEVERE STORMS AND FLOODING	Severe Storm	3
4394	45051	2018-09-16	5	5	5	1.133269e+06	1133268.54	2.318340e+04	2018	348574	6.455071e+10	98.9818645	61.30	HURRICANE FLORENCE	Hurricane	4
4394	45067	2018-09-16	1	1	1	3.117154e+05	311715.36	8.890000e+02	2018	29137	6.028669e+09	85.9688196	22.53	HURRICANE FLORENCE	Hurricane	4
4394	45069	2018-09-16	2	2	2	3.618326e+05	361832.64	8.050788e+05	2018	26656	3.804431e+09	65.6379255	17.79	HURRICANE FLORENCE	Hurricane	4
4394	45079	2018-09-16	1	1	1	3.803872e+05	380387.21	1.033740e+04	2018	415644	8.168495e+10	93.3503023	74.19	HURRICANE FLORENCE	Hurricane	4
4411	51760	2018-12-18	1	1	1	2.351660e+03	2351.66	2.000000e+01	2018	226269	4.353533e+10	73.2421254	54.84	TROPICAL STORM MICHAEL	Hurricane	3
4383	55025	2018-08-10	1	1	1	2.871043e+04	28710.43	9.000000e+01	2018	561270	1.345952e+11	90.7413299	98.28	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4402	55025	2018-10-18	1	1	1	8.192215e+04	81922.15	3.497000e+02	2018	561270	1.345952e+11	90.7413299	98.28	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES	Flood	5
4402	55077	2018-10-18	1	1	1	9.180000e+03	9180.00	3.600000e+02	2018	15562	4.275948e+09	24.3716195	56.30	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES	Flood	5
4402	55081	2018-10-18	1	1	1	3.639500e+03	3639.50	1.767480e+03	2018	46230	1.119403e+10	62.1380846	72.15	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES	Flood	5
4402	55111	2018-10-18	2	2	2	2.592182e+04	25921.82	1.745324e+04	2018	65699	1.686294e+10	59.6245625	89.78	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES	Flood	5
4402	55123	2018-10-18	1	1	1	4.997230e+03	4997.23	2.300000e+02	2018	30574	7.252761e+09	51.1294941	73.93	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES	Flood	5
4426	01019	2019-04-17	1	1	1	4.766280e+03	4766.28	8.576000e+02	2019	24933	4.433991e+09	42.0617245	13.59	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	4
4426	01059	2019-04-17	1	1	1	2.113192e+04	21131.92	1.499885e+00	2019	31999	5.620840e+09	65.4788419	19.10	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	4
4419	01081	2019-03-05	4	1	1	1.255144e+07	6275717.54	3.364800e+02	2019	173871	2.952116e+10	70.8240535	46.66	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	4
4413	02020	2019-01-31	4	4	4	5.578337e+05	557220.97	7.816600e+04	2019	290985	6.439078e+10	94.8456888	51.08	EARTHQUAKE	Earthquake	10
4413	02122	2019-01-31	1	1	1	1.373895e+04	13738.95	2.800000e+01	2019	58731	1.887690e+10	90.9640471	10.38	EARTHQUAKE	Earthquake	10
4441	05069	2019-06-08	1	1	1	9.373240e+03	9373.24	1.800000e+01	2019	67108	1.350750e+10	84.2507159	50.64	SEVERE STORMS AND FLOODING	Flood	6
4441	05105	2019-06-08	1	1	1	4.917481e+04	49174.81	2.261666e+04	2019	10019	1.476877e+09	40.7572383	19.45	SEVERE STORMS AND FLOODING	Flood	6
4441	05119	2019-06-08	4	1	1	7.177875e+05	358893.74	1.010320e+05	2019	398830	7.392333e+10	95.0684060	73.68	SEVERE STORMS AND FLOODING	Flood	6
4441	05131	2019-06-08	2	2	2	3.248890e+05	324888.95	5.230000e+03	2019	127706	2.475716e+10	83.9325485	42.52	SEVERE STORMS AND FLOODING	Flood	6
4434	06007	2019-05-18	1	1	1	1.030990e+05	103099.04	2.000000e+00	2019	211490	4.251521e+10	97.1683105	62.41	SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	9
4431	06065	2019-05-01	1	1	1	6.413386e+04	64133.86	8.000000e+00	2019	2416838	4.187359e+11	99.9363665	27.43	SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	9
4434	06097	2019-05-18	1	1	1	1.316370e+04	13163.70	7.200000e+02	2019	488330	1.046105e+11	99.1727649	72.98	SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	9
4443	16049	2019-06-12	1	1	1	3.722360e+03	3722.36	6.000000e+01	2019	16440	6.597193e+09	80.9099586	16.84	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4461	17149	2019-09-19	1	1	1	1.559100e+02	155.91	3.000000e+00	2019	14724	1.604249e+09	18.5173401	53.91	SEVERE STORMS AND FLOODING	Flood	5
4461	17167	2019-09-19	1	1	1	3.298103e+05	329810.35	3.992000e+01	2019	196182	5.681118e+10	88.5459752	91.31	SEVERE STORMS AND FLOODING	Flood	5
4461	17171	2019-09-19	4	1	1	2.268457e+05	113422.86	2.740000e+03	2019	4937	4.463794e+08	7.9541839	73.71	SEVERE STORMS AND FLOODING	Flood	5
4421	19017	2019-03-23	1	1	1	2.409320e+04	24093.20	7.230000e+02	2019	24970	6.061426e+09	38.3391664	99.20	SEVERE STORMS AND FLOODING	Flood	7
4421	19071	2019-03-23	35348	2	2	6.892466e+09	36853128.84	6.315800e+05	2019	6605	2.092445e+09	38.1800827	64.19	SEVERE STORMS AND FLOODING	Flood	7
4421	19085	2019-03-23	1	1	1	4.015405e+04	40154.05	2.400000e+03	2019	14559	3.415922e+09	49.4432071	75.33	SEVERE STORMS AND FLOODING	Flood	7
4421	19129	2019-03-23	51	3	3	8.031916e+06	1194916.74	2.314703e+03	2019	14475	3.454378e+09	38.7527840	86.28	SEVERE STORMS AND FLOODING	Flood	7
4421	19163	2019-03-23	1	1	1	1.460323e+04	14603.23	1.093400e+04	2019	174636	3.898570e+10	82.0553611	95.74	SEVERE STORMS AND FLOODING	Flood	7
4421	19193	2019-03-23	1	1	1	2.911463e+04	29114.63	4.920000e+02	2019	105853	1.931667e+10	83.4552975	93.57	SEVERE STORMS AND FLOODING	Flood	7
4449	20015	2019-06-20	1	1	1	3.870808e+04	38708.08	9.600000e+01	2019	67340	1.296721e+10	80.2099905	70.88	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20017	2019-06-20	1	1	1	7.503620e+03	7503.62	3.000000e+01	2019	2564	8.990594e+08	25.1352211	45.45	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20035	2019-06-20	1	1	1	1.308647e+05	130864.71	7.680000e+02	2019	34541	7.569744e+09	74.5466115	70.62	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20045	2019-06-20	1	1	1	5.426368e+05	542636.85	1.463560e+03	2019	118666	2.450489e+10	79.6372892	79.79	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20047	2019-06-20	1	1	1	3.323396e+04	33233.96	3.240000e+02	2019	2905	1.061872e+09	16.0038180	50.57	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20103	2019-06-20	10	2	2	1.713647e+06	804904.23	1.475522e+04	2019	81853	1.587767e+10	74.1966274	73.81	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4449	20165	2019-06-20	1	1	1	3.980870e+03	3980.87	1.999800e+04	2019	2952	1.656550e+09	23.6080178	82.69	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES	Severe Storm	7
4458	22007	2019-08-27	1	1	1	1.031278e+05	103127.79	1.022700e+03	2019	21017	3.291188e+09	86.3506204	48.89	HURRICANE BARRY	Hurricane	6
4458	22033	2019-08-27	4	1	1	2.469997e+06	1234998.62	2.822000e+03	2019	456512	1.120657e+11	98.8864143	60.09	HURRICANE BARRY	Hurricane	6
4439	22061	2019-06-03	3	3	2	8.330467e+05	833046.71	4.647900e+04	2019	48370	8.006832e+09	68.6605154	40.74	SEVERE STORMS AND TORNADOES	Severe Storm	6
4458	22075	2019-08-27	1	1	1	3.609046e+04	36090.46	2.000000e+00	2019	23448	4.870262e+09	82.6916958	94.33	HURRICANE BARRY	Hurricane	6
4458	22101	2019-08-27	1	1	1	5.739858e+05	573985.77	2.000000e+00	2019	49313	1.172348e+10	94.7184219	78.13	HURRICANE BARRY	Hurricane	6
4458	22109	2019-08-27	1	1	1	6.443827e+05	644382.71	1.625000e+03	2019	109484	2.195670e+10	96.3728921	94.75	HURRICANE BARRY	Hurricane	6
4442	27013	2019-06-12	1	1	1	1.025361e+04	10253.61	2.612800e+04	2019	69073	1.557987e+10	68.0559975	98.76	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4442	27027	2019-06-12	1	1	1	2.259967e+04	22599.67	1.000000e+01	2019	65291	1.448070e+10	58.6700605	85.74	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4414	27137	2019-02-01	1	1	1	2.187556e+05	218755.60	2.027750e+03	2019	200067	5.200865e+10	66.5287941	98.73	SEVERE STORMS AND FLOODING	Flood	5
4442	27173	2019-06-12	1	1	1	7.070390e+03	7070.39	4.980000e+01	2019	9528	2.993936e+09	24.6579701	94.14	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4450	28023	2019-06-20	1	1	1	1.185000e+04	11850.00	1.170000e+02	2019	15570	2.563118e+09	50.6522431	21.16	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4415	28035	2019-02-14	1	1	1	1.032558e+04	10325.58	3.600000e+02	2019	78050	1.342654e+10	86.5415208	59.10	SEVERE STORMS, FLOODING, AND TORNADO	Severe Storm	4
4470	28081	2019-12-06	1	1	1	2.390359e+05	239035.94	1.610000e+03	2019	83269	1.698476e+10	79.0009545	62.38	SEVERE STORM, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4429	28087	2019-04-23	2	2	2	7.591174e+05	759117.40	4.321300e+03	2019	58845	1.178985e+10	77.6328349	56.91	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	4
4450	28095	2019-06-20	1	1	1	2.144422e+06	2144422.14	8.078800e+03	2019	34055	5.885635e+09	63.0607700	43.76	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4429	28163	2019-04-23	1	1	1	4.868720e+03	4868.72	4.940000e+04	2019	26703	3.860836e+09	71.7149220	7.45	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	4
4435	29005	2019-05-20	20	2	2	1.077995e+06	312080.06	6.880000e+01	2019	5305	1.510889e+09	30.2258988	66.77	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4451	29009	2019-07-09	1	1	1	1.475490e+04	14754.90	1.199908e+04	2019	34451	8.444012e+09	77.9510022	22.69	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4435	29021	2019-05-20	4	1	1	3.153960e+04	15769.80	1.518520e+01	2019	84731	1.765838e+10	69.3923003	89.50	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4451	29033	2019-07-09	1	1	1	1.624925e+05	162492.50	6.131000e+03	2019	8482	2.270868e+09	42.4117086	77.08	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29041	2019-07-09	2	2	2	4.824655e+04	48246.55	3.670000e+02	2019	7366	2.765102e+09	21.5717467	72.12	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4435	29051	2019-05-20	1	1	1	4.047692e+04	40476.92	8.000000e+01	2019	76989	1.757678e+10	74.6102450	90.67	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4451	29051	2019-07-09	4	4	4	1.755094e+06	1755093.68	3.000406e+06	2019	76989	1.757678e+10	74.6102450	90.67	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4435	29087	2019-05-20	1	1	1	4.245427e+04	42454.27	2.581000e+03	2019	4210	1.812408e+09	23.4171174	63.34	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4451	29087	2019-07-09	1	1	1	3.051100e+04	30511.00	3.940000e+01	2019	4210	1.812408e+09	23.4171174	63.34	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29095	2019-07-09	1	1	1	1.300000e+04	13000.00	5.000000e+02	2019	716764	1.359077e+11	95.6092905	61.52	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29097	2019-07-09	1	1	1	1.910665e+05	191066.47	2.040000e+02	2019	122722	2.462236e+10	84.6961502	57.80	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29113	2019-07-09	2	2	2	3.299964e+04	32999.64	2.160000e+03	2019	59458	1.051751e+10	73.1148584	78.49	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29131	2019-07-09	1	1	1	3.319481e+04	33194.81	8.162275e+01	2019	24682	6.380061e+09	60.8017817	36.95	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29145	2019-07-09	1	1	1	1.335495e+04	13354.95	2.440000e+02	2019	58493	1.241102e+10	81.8008272	44.56	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29163	2019-07-09	1	1	1	8.439171e+04	84391.71	2.000000e+02	2019	17548	4.436404e+09	41.1708559	56.94	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29177	2019-07-09	4	1	1	1.927000e+05	96350.00	7.666666e+02	2019	23141	4.416857e+09	30.0668151	78.58	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29183	2019-07-09	2	2	2	1.358411e+06	1032853.07	8.800000e+02	2019	405183	8.092181e+10	93.0003182	96.24	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4451	29195	2019-07-09	1	1	1	1.200000e+04	12000.00	6.920000e+02	2019	23279	4.980690e+09	46.4842507	72.66	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	7
4420	31015	2019-03-21	36	1	1	4.304275e+05	71737.92	1.764000e+03	2019	1810	8.006031e+08	5.4088451	42.65	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31019	2019-03-21	1	1	1	2.907830e+04	29078.30	2.000000e+00	2019	50007	1.014431e+10	79.4463888	75.59	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31023	2019-03-21	1	1	1	1.585415e+05	158541.48	3.029140e+04	2019	8354	2.690794e+09	38.5618836	80.78	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31027	2019-03-21	2	2	2	8.846910e+03	8846.91	2.724560e+03	2019	8361	2.960310e+09	32.8985046	55.51	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31053	2019-03-21	2	2	2	3.373705e+05	337370.49	5.356880e+03	2019	37166	8.678864e+09	79.4782055	84.31	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31055	2019-03-21	3	3	3	5.094115e+05	509411.54	8.864000e+03	2019	584427	1.025738e+11	95.6729240	82.78	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31079	2019-03-21	1	1	1	5.773112e+04	57731.12	1.006000e+03	2019	62826	1.107112e+10	84.2825326	69.26	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31093	2019-03-21	1	1	1	1.283799e+04	12837.99	3.290060e+02	2019	6475	1.721276e+09	52.1476297	56.11	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31097	2019-03-21	1	1	1	4.448106e+04	44481.06	8.000000e+00	2019	5288	1.325388e+09	13.6493796	67.85	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31107	2019-03-21	1	1	1	2.877048e+04	28770.48	1.500000e+02	2019	8383	3.127981e+09	35.8574610	47.71	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31127	2019-03-21	125	2	2	4.036525e+07	4174301.65	5.708050e+03	2019	7072	1.812901e+09	24.4670697	66.61	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31139	2019-03-21	1	1	1	1.810620e+04	18106.20	1.146000e+03	2019	7312	2.229682e+09	19.5991091	73.39	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31141	2019-03-21	2	2	2	1.167394e+04	11673.94	2.920000e+03	2019	34261	7.898105e+09	75.2465797	67.03	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4420	31153	2019-03-21	3	3	3	1.905860e+05	190585.96	2.621230e+03	2019	190379	3.342189e+10	88.1641744	91.50	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING	Flood	7
4472	36043	2019-12-19	2	2	2	7.956687e+04	79566.87	2.690000e+02	2019	60103	1.338981e+10	34.7438753	84.40	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	2
4472	36065	2019-12-19	1	1	1	6.987899e+04	69878.99	7.116400e+02	2019	232037	4.466933e+10	72.0330894	89.62	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	2
4472	36075	2019-12-19	1	1	1	1.467824e+04	14678.24	1.578900e+04	2019	117511	2.311243e+10	28.7305122	83.67	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	2
4465	37031	2019-10-04	1	1	1	1.620020e+05	162002.05	3.329200e+04	2019	67625	1.740755e+10	97.1046771	83.10	HURRICANE DORIAN	Hurricane	4
4465	37049	2019-10-04	2	2	2	4.245355e+05	424535.48	7.320000e+04	2019	100042	1.736429e+10	96.4047089	65.63	HURRICANE DORIAN	Hurricane	4
4412	37055	2019-01-31	5	5	5	2.888472e+05	288847.15	4.965800e+03	2019	36860	1.259747e+10	95.4820235	99.59	TROPICAL STORM MICHAEL	Hurricane	4
4465	37055	2019-10-04	5	5	5	3.087902e+06	3087902.38	9.388458e+04	2019	36860	1.259747e+10	95.4820235	99.59	HURRICANE DORIAN	Hurricane	4
4465	37095	2019-10-04	1	1	1	3.121502e+06	3121502.49	4.666667e+03	2019	4573	1.146907e+09	82.5962456	35.84	HURRICANE DORIAN	Hurricane	4
4465	37107	2019-10-04	1	1	1	1.053932e+04	10539.32	7.128000e+03	2019	55112	1.175561e+10	91.7912822	52.51	HURRICANE DORIAN	Hurricane	4
4465	37177	2019-10-04	1	1	1	8.772494e+05	877249.43	9.887500e+02	2019	3245	1.018921e+09	74.2920776	39.12	HURRICANE DORIAN	Hurricane	4
4412	37183	2019-01-31	2	2	2	1.348062e+06	1348061.53	3.384440e+03	2019	1128357	2.152861e+11	93.6366529	72.02	TROPICAL STORM MICHAEL	Hurricane	4
4465	37183	2019-10-04	1	1	1	8.650087e+05	865008.67	1.400000e+04	2019	1128357	2.152861e+11	93.6366529	72.02	HURRICANE DORIAN	Hurricane	4
4447	39057	2019-06-18	1	1	1	3.769586e+04	37695.86	5.000000e+00	2019	167939	3.290457e+10	64.2061724	87.49	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE	Tornado	5
4447	39107	2019-06-18	1	1	1	2.019599e+04	20195.99	1.232000e+02	2019	42522	1.348284e+10	57.6519249	97.33	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE	Tornado	5
4447	39113	2019-06-18	8	8	8	2.472149e+06	2472148.94	6.668112e+04	2019	537193	9.945173e+10	86.0960865	76.00	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE	Tornado	5
4438	40017	2019-06-01	1	1	1	8.616910e+03	8616.91	6.840000e+02	2019	153947	2.257507e+10	87.7823735	69.06	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40101	2019-06-01	3	3	3	2.644650e+05	264465.01	3.467000e+03	2019	66200	1.142326e+10	83.1689469	40.48	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40109	2019-06-01	1	1	1	8.379840e+04	83798.40	1.000000e+01	2019	795336	1.289742e+11	97.2637607	45.86	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40113	2019-06-01	2	2	2	2.286860e+04	22868.60	8.850000e+02	2019	45705	6.963588e+09	73.7511931	37.14	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40131	2019-06-01	1	1	1	3.210613e+04	32106.13	5.700000e+02	2019	95011	1.477543e+10	80.5281578	65.12	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40135	2019-06-01	1	1	1	8.789225e+04	87892.25	4.500000e+03	2019	39237	4.932920e+09	77.0601336	7.10	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4438	40143	2019-06-01	2	2	2	3.772521e+05	377252.08	5.694400e+02	2019	668481	1.157878e+11	96.6274260	53.69	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	6
4452	41059	2019-07-09	2	2	2	5.186247e+04	51862.47	1.744720e+03	2019	79888	1.861261e+10	76.5510659	23.52	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4464	45051	2019-09-30	1	1	1	1.850597e+05	185059.66	6.648000e+03	2019	348574	6.455071e+10	98.9818645	61.30	HURRICANE DORIAN	Hurricane	4
4440	46035	2019-06-07	1	1	1	6.642263e+04	66422.63	4.440000e+02	2019	19950	5.204129e+09	63.6334712	87.78	SEVERE WINTER STORM, SNOWSTORM, AND FLOODING	Flood	8
4469	46061	2019-11-18	1	1	1	4.040610e+03	4040.61	2.100000e+02	2019	3461	1.064278e+09	12.7903277	96.02	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	8
4440	46065	2019-06-07	1	1	1	7.311930e+04	73119.30	2.600000e+02	2019	17751	3.816304e+09	47.1205854	85.90	SEVERE WINTER STORM, SNOWSTORM, AND FLOODING	Flood	8
4469	46087	2019-11-18	1	1	1	9.704700e+03	9704.70	5.400000e+02	2019	5682	1.196086e+10	69.1059497	88.70	SEVERE STORMS, TORNADOES, AND FLOODING	Severe Storm	8
4440	46099	2019-06-07	1	1	1	1.320918e+05	132091.75	1.093400e+04	2019	196891	3.733547e+10	92.5867006	93.13	SEVERE WINTER STORM, SNOWSTORM, AND FLOODING	Flood	8
4427	47071	2019-04-17	2	2	2	7.440183e+04	74401.83	1.376620e+03	2019	26745	4.834413e+09	52.4021635	34.09	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4427	47093	2019-04-17	1	1	1	1.079972e+04	10799.72	3.140000e+02	2019	478842	8.234800e+10	89.4368438	62.22	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4471	47125	2019-12-06	1	1	1	1.461950e+06	1461949.54	6.600000e+01	2019	220041	3.013971e+10	85.5870188	50.54	SEVERE STORM AND STRAIGHT-LINE WINDS	Severe Storm	4
4427	47143	2019-04-17	1	1	1	2.096225e+04	20962.25	1.600000e+02	2019	32839	5.385350e+09	49.1250398	34.88	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4416	48053	2019-02-25	2	2	2	2.982315e+05	298231.52	5.002000e+03	2019	48986	9.610927e+09	80.1463570	42.39	SEVERE STORMS AND FLOODING	Flood	6
4416	48207	2019-02-25	1	1	1	4.967730e+03	4967.73	2.790000e+01	2019	5414	2.023697e+09	23.1307668	20.24	SEVERE STORMS AND FLOODING	Flood	6
4416	48267	2019-02-25	1	1	1	1.224471e+04	12244.71	1.900000e+01	2019	4271	2.532014e+09	46.0388164	21.29	SEVERE STORMS AND FLOODING	Flood	6
4416	48271	2019-02-25	1	1	1	3.613436e+04	36134.36	3.330000e+02	2019	3126	5.383794e+08	1.5590200	1.05	SEVERE STORMS AND FLOODING	Flood	6
4416	48299	2019-02-25	2	2	2	1.316702e+06	1316701.55	6.616000e+03	2019	21199	5.462515e+09	68.5650652	19.92	SEVERE STORMS AND FLOODING	Flood	6
4416	48453	2019-02-25	2	2	2	3.416851e+05	341685.14	7.812000e+02	2019	1285769	1.895386e+11	96.8819599	56.75	SEVERE STORMS AND FLOODING	Flood	6
4418	53009	2019-03-04	1	1	1	1.171479e+04	11714.79	2.000000e+01	2019	77054	1.511825e+10	87.4960229	56.37	SEVERE WINTER STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, MUDSLIDES, TORNADO	Severe Storm	10
4563	01003	2020-09-20	17	17	16	6.077548e+07	60775477.28	3.868044e+05	2020	231365	4.596848e+10	97.7091950	86.12	HURRICANE SALLY	Hurricane	4
4554	01037	2020-07-10	1	1	1	1.173505e+04	1000.00	2.200000e+02	2020	10320	1.954999e+09	7.5087496	21.71	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4554	01041	2020-07-10	1	1	1	1.267207e+05	126720.69	2.880000e+02	2020	13179	2.563555e+09	46.2615336	21.20	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4555	01055	2020-07-10	1	1	1	3.220261e+05	322026.12	7.111200e+04	2020	103320	1.900045e+10	82.2462615	53.66	SEVERE THUNDERSTORMS	Severe Storm	4
4555	01095	2020-07-10	1	1	1	3.102030e+05	310203.01	5.422000e+03	2020	97552	1.736259e+10	85.1734012	40.39	SEVERE THUNDERSTORMS	Severe Storm	4
4563	01097	2020-09-20	6	6	6	1.465248e+07	14652476.51	6.677400e+04	2020	414514	7.602302e+10	98.7909640	74.60	HURRICANE SALLY	Hurricane	4
4573	01097	2020-12-10	2	2	2	6.170848e+06	6170848.44	4.713560e+04	2020	414514	7.602302e+10	98.7909640	74.60	HURRICANE ZETA	Hurricane	4
4563	01101	2020-09-20	1	1	1	1.361660e+07	13616603.44	6.238100e+04	2020	228847	4.622347e+10	86.2551702	67.92	HURRICANE SALLY	Hurricane	4
4573	01101	2020-12-10	1	1	1	6.884084e+06	6884084.00	3.200000e+01	2020	228847	4.622347e+10	86.2551702	67.92	HURRICANE ZETA	Hurricane	4
4554	01109	2020-07-10	1	1	1	3.247833e+05	324783.32	1.250000e+04	2020	32965	6.512703e+09	63.2516704	49.52	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4544	05031	2020-05-08	1	1	1	3.296069e+05	229606.89	1.046000e+03	2020	111202	1.973483e+10	92.3321667	52.10	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Tornado	6
4556	05107	2020-07-10	1	1	1	1.386589e+05	138658.92	1.200000e+02	2020	16523	3.246568e+09	65.2879415	32.27	SEVERE STORMS AND STRAIGHT-LINE WINDS	Tornado	6
4544	05119	2020-05-08	1	1	1	5.737772e+04	57377.72	2.470000e+03	2020	398830	7.392333e+10	95.0684060	73.68	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Tornado	6
4558	06053	2020-08-22	1	1	1	1.490270e+03	1490.27	4.000000e+01	2020	438599	7.640694e+10	98.3773465	28.90	WILDFIRES	Fire	9
4558	06107	2020-08-22	1	1	1	1.269005e+04	12690.05	1.069444e+05	2020	472585	7.447368e+10	95.7683742	12.83	WILDFIRES	Fire	9
4566	10001	2020-10-02	1	1	1	4.155000e+04	41550.00	1.069444e+05	2020	181705	3.268465e+10	84.7597836	72.95	TROPICAL STORM ISAIAS	Hurricane	3
4566	10003	2020-10-02	1	1	1	3.055757e+05	305575.72	0.000000e+00	2020	570089	1.221791e+11	90.7731467	83.26	TROPICAL STORM ISAIAS	Hurricane	3
4564	12033	2020-09-23	3	3	3	2.909541e+07	29095409.43	2.338336e+05	2020	321367	5.111437e+10	97.8682787	45.51	HURRICANE SALLY	Hurricane	4
4564	12091	2020-09-23	2	2	2	3.797345e+05	379734.48	1.500740e+04	2020	211293	3.597393e+10	97.4228444	45.23	HURRICANE SALLY	Hurricane	4
4564	12113	2020-09-23	5	5	5	1.126164e+07	11261636.35	1.832020e+05	2020	187714	2.541006e+10	95.5138403	53.44	HURRICANE SALLY	Hurricane	4
4557	19011	2020-08-17	5	5	5	9.713339e+05	831333.87	9.875060e+03	2020	25558	6.813448e+09	48.2978046	96.63	SEVERE STORMS	Severe Storm	7
4557	19091	2020-08-17	1	1	1	4.134500e+04	41345.00	3.083050e+05	2020	9597	2.200834e+09	29.6531976	84.66	SEVERE STORMS	Severe Storm	7
4557	19113	2020-08-17	10	10	10	3.943399e+07	39044990.73	3.049568e+05	2020	230253	4.843057e+10	91.7276487	99.24	SEVERE STORMS	Severe Storm	7
4557	19127	2020-08-17	1	1	1	2.989031e+04	29890.31	6.166100e+05	2020	40092	1.087537e+10	68.8514158	68.52	SEVERE STORMS	Severe Storm	7
4557	19153	2020-08-17	1	1	1	1.364581e+05	136458.10	5.170000e+03	2020	492316	9.393685e+10	91.5367483	95.58	SEVERE STORMS	Severe Storm	7
4557	19169	2020-08-17	1	1	1	2.224314e+05	143431.44	8.834000e+01	2020	98533	1.981740e+10	76.0101814	88.89	SEVERE STORMS	Severe Storm	7
4557	19171	2020-08-17	1	1	1	1.856669e+06	1831668.66	1.224500e+03	2020	17081	4.591618e+09	52.7203309	72.60	SEVERE STORMS	Severe Storm	7
4561	19171	2020-09-10	4	1	1	4.090607e+06	2045303.40	9.537600e+02	2020	17081	4.591618e+09	52.7203309	72.60	SEVERE STORMS AND STRAIGHT-LINE WINDS	Severe Storm	7
4559	22001	2020-08-28	5	2	2	6.386554e+06	3916511.30	1.418255e+04	2020	57475	1.082074e+10	90.5186128	29.76	HURRICANE LAURA	Hurricane	6
4559	22003	2020-08-28	5	5	5	1.616527e+07	16165273.67	1.394995e+04	2020	22708	3.900954e+09	64.0470888	30.68	HURRICANE LAURA	Hurricane	6
4559	22011	2020-08-28	2	2	2	1.026766e+07	10267664.01	7.287010e+04	2020	36508	6.482271e+09	71.8421890	32.24	HURRICANE LAURA	Hurricane	6
4559	22019	2020-08-28	44	35	35	6.907878e+08	555991104.37	5.851407e+06	2020	216652	4.227924e+10	96.9137766	32.40	HURRICANE LAURA	Hurricane	6
4559	22023	2020-08-28	10	4	4	1.295674e+08	64864742.74	1.603246e+06	2020	5615	1.108910e+09	55.8065542	95.04	HURRICANE LAURA	Hurricane	6
4559	22033	2020-08-28	18	6	6	2.262258e+08	116704985.16	6.778400e+05	2020	456512	1.120657e+11	98.8864143	60.09	HURRICANE LAURA	Hurricane	6
4570	22033	2020-10-16	1	1	1	2.712772e+05	271277.18	5.800000e+01	2020	456512	1.120657e+11	98.8864143	60.09	HURRICANE DELTA	Hurricane	6
4559	22043	2020-08-28	2	2	2	1.588890e+07	15888904.87	4.963000e+03	2020	22122	3.090163e+09	33.6939230	20.78	HURRICANE LAURA	Hurricane	6
4559	22053	2020-08-28	7	7	7	7.302015e+06	7302015.49	3.913800e+04	2020	32235	5.698292e+09	88.4505250	30.11	HURRICANE LAURA	Hurricane	6
4559	22055	2020-08-28	1	1	1	6.092992e+04	60929.92	2.462600e+04	2020	241618	4.511250e+10	97.9637289	64.35	HURRICANE LAURA	Hurricane	6
4570	22055	2020-10-16	6	6	6	7.435385e+06	7435385.23	9.698600e+03	2020	241618	4.511250e+10	97.9637289	64.35	HURRICANE DELTA	Hurricane	6
4559	22073	2020-08-28	3	3	3	3.422428e+06	3422427.84	1.416077e+04	2020	160298	2.846186e+10	85.6188355	69.29	HURRICANE LAURA	Hurricane	6
4559	22079	2020-08-28	1	1	1	4.254576e+06	4254575.96	5.706400e+03	2020	129664	2.330566e+10	83.3916640	71.26	HURRICANE LAURA	Hurricane	6
4570	22079	2020-10-16	1	1	1	7.058359e+04	70583.59	2.468800e+02	2020	129664	2.330566e+10	83.3916640	71.26	HURRICANE DELTA	Hurricane	6
4570	22099	2020-10-16	2	2	2	8.980032e+05	898003.24	7.142000e+02	2020	51686	8.428679e+09	91.3140312	75.75	HURRICANE DELTA	Hurricane	6
4559	22113	2020-08-28	2	2	2	6.045695e+06	6045694.95	2.477365e+04	2020	57317	7.237194e+09	89.8504613	70.69	HURRICANE LAURA	Hurricane	6
4570	22113	2020-10-16	1	1	1	6.183000e+03	6183.00	7.000000e+00	2020	57317	7.237194e+09	89.8504613	70.69	HURRICANE DELTA	Hurricane	6
4559	22115	2020-08-28	6	3	3	1.323466e+07	13204536.75	3.839000e+03	2020	48626	7.312746e+09	73.3057588	14.13	HURRICANE LAURA	Hurricane	6
4559	22127	2020-08-28	2	2	2	2.709224e+06	2709224.08	1.168000e+03	2020	13718	2.335246e+09	22.1444480	37.84	HURRICANE LAURA	Hurricane	6
4547	26051	2020-07-09	1	1	1	3.552391e+04	35523.91	8.000000e+03	2020	25371	6.556040e+09	15.1447661	52.45	SEVERE STORMS AND FLOODING	Dam/Levee Break	5
4547	26111	2020-07-09	1	1	1	3.983990e+03	3983.99	2.240000e+02	2020	83456	1.828456e+10	64.9061406	94.05	SEVERE STORMS AND FLOODING	Dam/Levee Break	5
4547	26145	2020-07-09	2	2	2	1.130423e+05	113042.31	1.027300e+04	2020	190067	3.667700e+10	79.0327712	91.63	SEVERE STORMS AND FLOODING	Dam/Levee Break	5
4478	28011	2020-03-12	1	1	1	5.523330e+03	5523.33	5.700000e+01	2020	30953	8.264811e+09	74.5147948	31.09	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4536	28031	2020-04-16	1	1	1	4.324141e+06	4324140.81	9.209000e+03	2020	18330	2.645445e+09	62.5198855	12.73	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4478	28033	2020-03-12	9	1	1	3.221308e+07	10737694.08	8.400000e+04	2020	185280	3.055907e+10	90.8367801	58.85	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4576	28035	2020-12-31	1	1	1	1.132038e+04	11320.38	3.000000e+01	2020	78050	1.342654e+10	86.5415208	59.10	HURRICANE ZETA	Hurricane	4
4576	28039	2020-12-31	2	2	2	8.130316e+05	813031.57	4.674000e+02	2020	24246	3.603370e+09	87.0505886	21.13	HURRICANE ZETA	Hurricane	4
4576	28045	2020-12-31	4	4	4	5.240651e+06	5240651.43	1.685384e+05	2020	46025	8.381827e+09	88.0687241	60.31	HURRICANE ZETA	Hurricane	4
4576	28047	2020-12-31	6	6	6	2.185101e+07	21851008.92	3.431663e+05	2020	208275	3.732934e+10	97.2001273	67.41	HURRICANE ZETA	Hurricane	4
4536	28049	2020-04-16	3	3	1	2.524624e+06	2524623.54	3.000000e+03	2020	227510	3.931969e+10	92.5548839	77.37	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4538	28049	2020-04-23	1	1	1	9.462838e+04	94628.38	1.104610e+03	2020	227510	3.931969e+10	92.5548839	77.37	SEVERE STORMS, FLOODING, AND MUDSLIDES	Severe Storm	4
4576	28059	2020-12-31	2	2	2	7.319181e+06	7319180.97	5.523345e+04	2020	143149	2.306976e+10	95.9910913	75.88	HURRICANE ZETA	Hurricane	4
4536	28061	2020-04-16	1	1	1	1.721371e+06	1721371.35	1.481800e+04	2020	16343	3.036074e+09	48.7750557	21.01	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4536	28065	2020-04-16	1	1	1	3.807595e+06	3807595.45	2.812100e+04	2020	11298	1.934606e+09	29.9395482	19.03	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4536	28067	2020-04-16	2	2	1	3.779986e+06	3779986.23	5.484920e+04	2020	67168	1.431544e+10	87.1460388	34.91	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4551	28067	2020-07-09	1	1	1	8.849760e+05	884975.98	2.179000e+03	2020	67168	1.431544e+10	87.1460388	34.91	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4536	28077	2020-04-16	1	1	1	5.800084e+05	580008.37	8.120000e+01	2020	12013	2.409621e+09	46.2933503	5.70	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4551	28077	2020-07-09	1	1	1	1.262454e+06	1262454.27	4.060000e+01	2020	12013	2.409621e+09	46.2933503	5.70	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4551	28113	2020-07-09	1	1	1	1.438483e+06	1438482.89	2.400000e+02	2020	40285	7.208143e+09	77.2192173	23.81	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4576	28131	2020-12-31	1	1	1	1.625053e+06	1625052.75	1.302000e+02	2020	18312	2.965992e+09	82.5326122	27.66	HURRICANE ZETA	Hurricane	4
4478	28135	2020-03-12	1	1	1	8.100000e+04	33000.00	2.194000e+04	2020	12658	1.655110e+09	45.2115813	9.87	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4536	28147	2020-04-16	1	1	1	9.336377e+05	933637.73	1.421300e+03	2020	13882	2.760510e+09	48.9341394	9.90	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4552	29143	2020-07-09	1	1	1	6.512325e+04	65123.25	9.000000e+01	2020	16354	3.863169e+09	82.8825962	28.36	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	7
4574	34003	2020-12-11	1	1	1	1.672281e+05	167228.12	1.200000e+02	2020	955459	1.836780e+11	98.6955138	62.64	TROPICAL STORM ISAIAS	Hurricane	2
4567	36059	2020-10-02	2	2	2	4.931242e+05	493124.20	1.357000e+03	2020	1395584	2.703602e+11	96.6592428	95.00	TROPICAL STORM ISAIAS	Hurricane	2
4568	37015	2020-10-14	1	1	1	5.983166e+04	59831.66	6.000000e+01	2020	17933	4.394099e+09	82.4371619	15.69	HURRICANE ISAIAS	Hurricane	4
4568	37019	2020-10-14	8	8	4	2.274001e+06	2274000.90	5.887770e+04	2020	136245	2.994477e+10	97.0410436	64.93	HURRICANE ISAIAS	Hurricane	4
4568	37129	2020-10-14	2	2	2	4.699046e+06	4699046.36	6.891000e+02	2020	225344	5.126031e+10	98.5046134	82.27	HURRICANE ISAIAS	Hurricane	4
4575	40051	2020-12-21	1	1	1	1.050575e+05	105057.50	7.200000e+03	2020	54565	8.711522e+09	78.0782692	49.01	SEVERE WINTER STORM	Severe Ice Storm	6
4562	41039	2020-09-15	2	2	2	1.213909e+04	12139.09	3.700000e+01	2020	382865	8.188156e+10	96.7865097	63.84	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	10
4562	41047	2020-09-15	3	3	3	8.992413e+06	8992413.15	6.880040e+04	2020	344064	6.280993e+10	96.7546930	50.06	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	10
4542	45073	2020-05-01	1	1	1	4.369333e+05	436933.33	8.550000e+05	2020	78560	1.733914e+10	65.8924594	40.04	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Severe Storm	4
4542	45077	2020-05-01	1	1	1	2.228122e+04	22281.22	2.000000e+00	2020	131341	2.464922e+10	59.0836780	47.17	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Severe Storm	4
4542	45079	2020-05-01	1	1	1	5.182857e+06	5182856.75	1.740600e+04	2020	415644	8.168495e+10	93.3503023	74.19	SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS	Severe Storm	4
4476	47005	2020-03-05	1	1	1	7.978907e+04	79789.07	5.150000e+02	2020	15849	2.410436e+09	37.0346802	12.57	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4541	47011	2020-04-24	1	1	1	1.293443e+06	1293442.96	5.083000e+03	2020	108482	1.789671e+10	77.4101177	49.14	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4476	47037	2020-03-05	4	4	4	3.338607e+06	3338606.98	5.377850e+04	2020	715485	1.402987e+11	96.5001591	63.08	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4550	47037	2020-07-09	1	1	1	8.015124e+05	801512.44	2.500000e+02	2020	715485	1.402987e+11	96.5001591	63.08	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4541	47065	2020-04-24	3	3	3	1.360949e+07	13603360.40	3.447911e+04	2020	365901	6.771230e+10	92.3958002	76.93	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Severe Storm	4
4476	47141	2020-03-05	1	1	1	6.051809e+05	605180.94	2.792500e+04	2020	79809	1.142029e+10	67.1333121	46.75	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4476	47149	2020-03-05	1	1	1	7.839498e+05	783949.84	2.815940e+03	2020	341253	6.433455e+10	88.2278078	70.53	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4476	47189	2020-03-05	2	2	2	2.390411e+06	2390410.80	1.349610e+05	2020	147693	2.799064e+10	79.7009227	66.07	SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING	Tornado	4
4572	48245	2020-12-09	1	1	1	2.058362e+05	205836.22	1.450000e+03	2020	256386	3.854901e+10	97.7410118	68.01	HURRICANE LAURA	Hurricane	6
4572	48351	2020-12-09	1	1	1	3.127118e+05	312711.84	3.560000e+02	2020	12151	2.050022e+09	47.8205536	3.72	HURRICANE LAURA	Hurricane	6
4572	48361	2020-12-09	1	1	1	1.385839e+07	13858386.42	7.337196e+04	2020	84645	1.477127e+10	96.5637926	63.75	HURRICANE LAURA	Hurricane	6
4572	48453	2020-12-09	2	2	2	2.896741e+07	28967410.41	2.809086e+05	2020	1285769	1.895386e+11	96.8819599	56.75	HURRICANE LAURA	Hurricane	6
4539	53033	2020-04-23	1	1	1	1.313171e+05	131317.08	1.866200e+02	2020	2268178	4.701211e+11	99.6500159	78.36	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4539	53067	2020-04-23	1	1	1	2.571660e+04	25716.60	1.400000e+04	2020	294398	5.744299e+10	96.2138085	71.90	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4473	72059	2020-01-16	1	1	1	4.936124e+05	493612.44	6.188000e+03	2020	17690	1.798984e+09	NA	NA	EARTHQUAKES	Earthquake	2
4473	72113	2020-01-16	3	3	3	8.767199e+04	87671.99	4.296124e+05	2020	137316	2.102578e+10	NA	NA	EARTHQUAKES	Earthquake	2
4596	01015	2021-04-26	1	1	1	3.238120e+06	3238120.48	1.215400e+03	2021	116250	2.269150e+10	84.3779828	46.72	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4596	01105	2021-04-26	1	1	1	7.302500e+05	730250.00	2.660000e+03	2021	8480	1.455191e+09	13.7130130	10.88	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4596	01117	2021-04-26	1	1	1	1.805876e+05	180587.60	1.500000e+02	2021	222782	4.221177e+10	87.4005727	74.09	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4585	02100	2021-02-17	1	1	1	2.884985e+05	288498.54	1.650802e+01	2021	2080	8.783506e+08	3.7225581	25.02	SEVERE STORM, FLOODING, LANDSLIDES, AND MUDSLIDES	Mud/Landslide	10
4610	06063	2021-08-24	1	1	1	4.300000e+03	4300.00	1.657000e+01	2021	19746	8.405356e+09	78.9691378	62.95	WILDFIRES	Fire	9
4634	08013	2021-12-31	3	3	3	1.156198e+06	1156197.82	1.142980e+05	2021	330652	6.223313e+10	89.5004773	71.01	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	8
4627	10003	2021-10-24	2	2	2	2.598896e+05	259889.60	6.838600e+02	2021	570089	1.221791e+11	90.7731467	83.26	REMNANTS OF HURRICANE IDA	Hurricane	3
3560	12086	2021-06-25	2	2	1	1.072216e+07	10722161.01	2.600000e+04	2021	2698679	3.195744e+11	99.8090996	37.11	SURFSIDE BUILDING COLLAPSE	Other	4
4600	13077	2021-05-05	3	3	3	4.371243e+06	4371242.55	7.118797e+05	2021	146099	2.776655e+10	67.6423799	59.99	SEVERE STORMS AND TORNADOES	Severe Storm	4
4589	16055	2021-03-04	1	1	1	3.438445e+05	343844.52	1.680000e+01	2021	171251	3.499817e+10	61.3108495	54.14	STRAIGHT-LINE WINDS	Severe Storm	10
4595	21007	2021-04-23	1	1	1	2.700000e+04	27000.00	5.220000e+02	2021	7718	1.561990e+09	44.6070633	42.23	SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4630	21009	2021-12-12	1	1	1	2.553630e+03	2553.63	1.440000e+02	2021	44465	8.877867e+09	66.4333439	47.20	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21033	2021-12-12	2	2	2	6.565992e+05	656599.23	4.155400e+04	2021	12649	2.503478e+09	53.7384664	32.94	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21047	2021-12-12	3	3	3	1.378318e+05	137831.79	3.264940e+03	2021	72692	1.162218e+10	84.3143493	51.56	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4595	21065	2021-04-23	2	2	2	7.166988e+04	71669.88	3.002000e+03	2021	14163	2.046989e+09	25.3897550	10.98	SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4630	21067	2021-12-12	65	2	2	2.116366e+07	2287470.95	5.827680e+03	2021	322301	5.665312e+10	88.2914413	72.09	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21073	2021-12-12	9	9	8	4.508859e+06	4508859.06	8.094045e+04	2021	51521	1.006136e+10	62.8062361	71.55	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21075	2021-12-12	2	2	2	4.228770e+05	422877.01	2.408400e+03	2021	6515	1.438054e+09	58.3200764	20.50	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21083	2021-12-12	3	3	3	1.526278e+04	3626.00	5.140000e+02	2021	36623	8.112734e+09	83.7734648	32.56	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21099	2021-12-12	2	2	2	6.256349e+04	62563.49	1.695000e+03	2021	19277	3.607581e+09	41.0435889	36.60	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21107	2021-12-12	7	4	4	8.368929e+06	8289847.64	2.587903e+05	2021	45395	9.084016e+09	75.4056634	58.31	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4595	21115	2021-04-23	1	1	1	2.840255e+04	28402.55	2.004440e+05	2021	22621	3.501458e+09	46.8978683	13.11	SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4630	21141	2021-12-12	1	1	1	6.720949e+04	67209.49	1.817030e+03	2021	27382	4.856890e+09	55.4247534	39.66	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21143	2021-12-12	2	2	2	2.288122e+06	2288121.96	5.186950e+04	2021	8663	1.923462e+09	32.0394528	19.41	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21155	2021-12-12	2	2	2	4.249877e+04	42498.77	3.304000e+02	2021	19521	4.044451e+09	33.3439389	61.90	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21157	2021-12-12	3	3	3	6.375770e+06	6375770.17	1.227147e+05	2021	31629	6.869117e+09	71.5876551	62.32	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21177	2021-12-12	1	1	1	1.314805e+06	1314805.15	2.451000e+04	2021	30928	5.279739e+09	50.7476933	36.44	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21183	2021-12-12	4	4	4	2.166854e+05	200593.15	6.134830e+04	2021	23745	5.697402e+09	52.4657970	50.32	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4630	21227	2021-12-12	6	6	6	4.548012e+06	4548012.41	7.190880e+04	2021	134482	2.463868e+10	83.0098632	64.99	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES	Tornado	4
4606	22005	2021-06-02	1	1	1	5.904640e+03	5904.64	2.930000e+02	2021	126426	3.019167e+10	96.2774419	88.45	SEVERE STORMS, TORNADOES, AND FLOODING	Flood	6
4611	22005	2021-08-29	15	12	12	1.647677e+07	14289528.63	3.485034e+04	2021	126426	3.019167e+10	96.2774419	88.45	HURRICANE IDA	Hurricane	6
4611	22007	2021-08-29	3	3	3	4.065902e+05	406590.23	8.911550e+03	2021	21017	3.291188e+09	86.3506204	48.89	HURRICANE IDA	Hurricane	6
4606	22019	2021-06-02	2	2	2	1.104108e+06	1104107.98	4.183475e+04	2021	216652	4.227924e+10	96.9137766	32.40	SEVERE STORMS, TORNADOES, AND FLOODING	Flood	6
4577	22033	2021-01-12	1	1	1	3.017367e+06	3017366.97	1.708700e+04	2021	456512	1.120657e+11	98.8864143	60.09	HURRICANE ZETA	Hurricane	6
4606	22033	2021-06-02	1	1	1	6.457675e+05	645767.50	2.963400e+04	2021	456512	1.120657e+11	98.8864143	60.09	SEVERE STORMS, TORNADOES, AND FLOODING	Flood	6
4611	22033	2021-08-29	9	9	9	1.156044e+08	115604437.67	7.387389e+05	2021	456512	1.120657e+11	98.8864143	60.09	HURRICANE IDA	Hurricane	6
4577	22051	2021-01-12	3	3	3	5.835583e+06	5835582.78	1.478800e+04	2021	440590	6.529661e+10	98.1546293	96.05	HURRICANE ZETA	Hurricane	6
4611	22051	2021-08-29	89	20	20	2.649678e+08	99902962.58	1.250207e+06	2021	440590	6.529661e+10	98.1546293	96.05	HURRICANE IDA	Hurricane	6
4577	22057	2021-01-12	1	1	1	1.131015e+06	1131015.01	2.927500e+04	2021	97393	1.283919e+10	94.4002545	91.34	HURRICANE ZETA	Hurricane	6
4611	22057	2021-08-29	135	12	12	1.004245e+08	58715475.40	1.685344e+06	2021	97393	1.283919e+10	94.4002545	91.34	HURRICANE IDA	Hurricane	6
4611	22063	2021-08-29	4	4	4	2.107511e+07	21075105.63	1.950200e+04	2021	142163	2.617953e+10	96.8501432	57.48	HURRICANE IDA	Hurricane	6
4577	22071	2021-01-12	2	2	2	3.092847e+06	3092847.22	1.125400e+04	2021	383606	5.814887e+10	96.9774101	99.40	HURRICANE ZETA	Hurricane	6
4611	22071	2021-08-29	13	13	13	1.316914e+07	13169142.82	1.539474e+05	2021	383606	5.814887e+10	96.9774101	99.40	HURRICANE IDA	Hurricane	6
4577	22075	2021-01-12	1	1	1	6.771487e+05	677148.67	1.914000e+03	2021	23448	4.870262e+09	82.6916958	94.33	HURRICANE ZETA	Hurricane	6
4611	22075	2021-08-29	4	4	4	1.631102e+07	16311021.01	5.243400e+04	2021	23448	4.870262e+09	82.6916958	94.33	HURRICANE IDA	Hurricane	6
4577	22087	2021-01-12	2	2	2	8.014001e+05	801400.14	9.757830e+03	2021	43709	6.549944e+09	86.6051543	91.79	HURRICANE ZETA	Hurricane	6
4611	22087	2021-08-29	6	6	6	2.141927e+06	2141926.92	2.646608e+04	2021	43709	6.549944e+09	86.6051543	91.79	HURRICANE IDA	Hurricane	6
4577	22089	2021-01-12	1	1	1	3.237694e+05	323769.37	3.958000e+02	2021	52479	8.228203e+09	90.3277124	99.97	HURRICANE ZETA	Hurricane	6
4611	22089	2021-08-29	23	12	12	2.490244e+07	24780398.10	5.848307e+05	2021	52479	8.228203e+09	90.3277124	99.97	HURRICANE IDA	Hurricane	6
4611	22091	2021-08-29	1	1	1	3.508953e+06	3508953.44	3.997500e+02	2021	10911	1.816039e+09	48.2659879	24.25	HURRICANE IDA	Hurricane	6
4611	22093	2021-08-29	9	6	6	7.269766e+06	4535671.86	3.920930e+04	2021	20169	4.201279e+09	76.8692332	96.82	HURRICANE IDA	Hurricane	6
4611	22095	2021-08-29	15	7	7	1.928605e+08	74935394.21	2.070212e+06	2021	42466	8.175506e+09	86.5733376	99.90	HURRICANE IDA	Hurricane	6
4611	22101	2021-08-29	2	2	2	3.020996e+05	302099.61	4.000000e+00	2021	49313	1.172348e+10	94.7184219	78.13	HURRICANE IDA	Hurricane	6
4611	22103	2021-08-29	10	10	10	5.641922e+07	56419218.21	1.991214e+05	2021	263870	4.368477e+10	97.8046452	87.91	HURRICANE IDA	Hurricane	6
4611	22105	2021-08-29	2	2	2	5.219528e+07	52195275.17	9.608625e+04	2021	132858	2.072858e+10	96.1501750	57.73	HURRICANE IDA	Hurricane	6
4577	22109	2021-01-12	1	1	1	1.438236e+05	143823.58	1.600000e+02	2021	109484	2.195670e+10	96.3728921	94.75	HURRICANE ZETA	Hurricane	6
4611	22109	2021-08-29	7	7	7	1.506119e+07	7449699.92	2.607010e+05	2021	109484	2.195670e+10	96.3728921	94.75	HURRICANE IDA	Hurricane	6
4611	22117	2021-08-29	2	2	2	2.580516e+05	258051.58	8.925000e+02	2021	45382	7.554000e+09	89.3732103	25.05	HURRICANE IDA	Hurricane	6
4607	26163	2021-07-15	8	8	8	1.203159e+07	12031592.63	3.671430e+04	2021	1792549	3.174907e+11	96.6910595	56.56	SEVERE STORMS, FLOODING, AND TORNADOES	Severe Storm	5
4598	28001	2021-05-04	1	1	1	7.753157e+05	775315.71	1.632000e+03	2021	29474	4.966114e+09	54.3748011	26.58	SEVERE WINTER STORMS	Severe Ice Storm	4
4626	28047	2021-10-23	1	1	1	5.200653e+05	520065.35	2.913900e+04	2021	208275	3.732934e+10	97.2001273	67.41	HURRICANE IDA	Hurricane	4
4614	34003	2021-09-05	34	26	26	4.099809e+06	3208893.03	2.447749e+05	2021	955459	1.836780e+11	98.6955138	62.64	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34013	2021-09-05	9	9	9	3.761962e+06	3761961.75	4.349900e+04	2021	863448	1.279945e+11	92.7457843	31.29	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34015	2021-09-05	3	3	3	4.259833e+05	425983.30	6.922440e+03	2021	302128	6.000103e+10	84.7279669	87.21	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34017	2021-09-05	8	8	7	1.538086e+06	1538086.36	2.920270e+04	2021	723485	8.143320e+10	95.3865733	38.16	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34019	2021-09-05	10	10	10	6.150691e+05	615069.08	1.364898e+04	2021	128867	3.828055e+10	79.3827553	94.46	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34021	2021-09-05	2	2	2	2.414260e+05	241425.98	1.634000e+03	2021	386483	8.246538e+10	93.0321349	73.65	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34023	2021-09-05	9	9	9	1.488941e+06	1488940.52	2.533134e+04	2021	862614	1.753605e+11	95.8638244	59.20	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34027	2021-09-05	1	1	1	1.852445e+05	185244.52	4.800000e+02	2021	508868	1.186671e+11	90.7095132	92.01	REMNANTS OF HURRICANE IDA	Hurricane	2
4597	34029	2021-04-28	2	2	2	2.492861e+04	24928.61	1.150000e+02	2021	636993	1.058262e+11	97.2319440	89.27	SEVERE WINTER STORM AND SNOWSTORM	Snowstorm	2
4614	34031	2021-09-05	14	14	10	1.659818e+06	1659818.14	1.883069e+05	2021	523958	7.427218e+10	89.6595609	41.88	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34035	2021-09-05	21	21	20	7.212616e+06	7212616.30	1.544265e+05	2021	345266	8.593257e+10	93.4139357	88.67	REMNANTS OF HURRICANE IDA	Hurricane	2
4614	34039	2021-09-05	17	17	16	3.877424e+06	3877424.30	1.535021e+06	2021	575179	9.266494e+10	92.4276169	38.29	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36005	2021-09-05	1	1	1	3.832720e+03	3832.72	4.000000e+01	2021	1471631	1.365967e+11	96.3092587	6.46	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36027	2021-09-05	1	1	1	5.614820e+03	5614.82	2.710300e+05	2021	295788	6.225758e+10	76.9328667	78.39	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36047	2021-09-05	1	1	1	1.131723e+04	11317.23	2.056400e+04	2021	2735309	3.306987e+11	98.1228126	9.45	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36059	2021-09-05	4	4	4	1.137343e+05	113734.29	7.278000e+02	2021	1395584	2.703602e+11	96.6592428	95.00	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36061	2021-09-05	1	1	1	3.063000e+04	30630.00	1.000000e+02	2021	1693650	2.601753e+11	96.1819917	49.97	REMNANTS OF HURRICANE IDA	Hurricane	2
4625	36067	2021-10-08	1	1	1	9.111608e+04	91116.08	1.295800e+04	2021	476419	9.074455e+10	76.6146993	90.29	REMNANTS OF TROPICAL STORM FRED	Hurricane	2
4615	36071	2021-09-05	1	1	1	8.258620e+03	8258.62	6.180000e+03	2021	401096	7.171433e+10	85.2052179	70.97	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36079	2021-09-05	1	1	1	1.198772e+04	11987.72	1.468000e+01	2021	97640	2.033413e+10	50.8431435	87.52	REMNANTS OF HURRICANE IDA	Hurricane	2
4625	36101	2021-10-08	2	2	2	1.437029e+05	143702.90	5.687660e+05	2021	93544	1.955800e+10	64.4288896	70.50	REMNANTS OF TROPICAL STORM FRED	Hurricane	2
4615	36103	2021-09-05	1	1	1	1.395300e+04	13953.00	1.940000e+03	2021	1524969	3.491028e+11	97.1364938	94.81	REMNANTS OF HURRICANE IDA	Hurricane	2
4615	36119	2021-09-05	17	17	17	4.703006e+06	4703005.94	8.306886e+04	2021	1002867	1.800880e+11	94.3048043	77.72	REMNANTS OF HURRICANE IDA	Hurricane	2
4617	37021	2021-09-08	1	1	1	3.450863e+05	345086.33	1.230000e+03	2021	269305	4.863094e+10	81.4826599	59.61	REMNANTS OF TROPICAL STORM FRED	Hurricane	4
4617	37087	2021-09-08	1	1	1	3.082492e+04	30824.92	2.274000e+03	2021	62051	1.040115e+10	61.8835507	50.80	REMNANTS OF TROPICAL STORM FRED	Hurricane	4
4588	37183	2021-03-03	9	1	1	6.166113e+05	205537.11	1.170600e+04	2021	1128357	2.152861e+11	93.6366529	72.02	TROPICAL STORM ETA	Severe Storm	4
4618	42017	2021-09-10	1	1	1	3.178184e+04	31781.84	1.500000e+02	2021	646216	1.587404e+11	92.2367165	80.33	REMNANTS OF HURRICANE IDA	Hurricane	3
4618	42029	2021-09-10	1	1	1	4.787584e+04	47875.84	0.000000e+00	2021	534152	1.458534e+11	91.9821826	86.00	REMNANTS OF HURRICANE IDA	Hurricane	3
4618	42043	2021-09-10	3	3	3	2.747946e+05	274794.56	5.555840e+04	2021	286115	6.227298e+10	89.3095768	97.49	REMNANTS OF HURRICANE IDA	Hurricane	3
4618	42091	2021-09-10	4	4	4	6.569060e+06	6569060.33	1.509200e+04	2021	856020	2.069151e+11	94.0820872	94.08	REMNANTS OF HURRICANE IDA	Hurricane	3
4618	42101	2021-09-10	1	1	1	1.099364e+05	108533.89	5.135800e+02	2021	1602305	2.598294e+11	98.1864461	42.84	REMNANTS OF HURRICANE IDA	Hurricane	3
4618	42133	2021-09-10	1	1	1	1.084047e+04	10840.47	2.000000e+00	2021	456310	8.409368e+10	83.9961820	90.48	REMNANTS OF HURRICANE IDA	Hurricane	3
4601	47037	2021-05-08	1	1	1	1.466241e+05	146624.09	2.916000e+03	2021	715485	1.402987e+11	96.5001591	63.08	SEVERE STORMS, TORNADOES, AND FLOODING	Tornado	4
4609	47037	2021-08-23	1	1	1	2.432929e+05	243292.87	1.593000e+04	2021	715485	1.402987e+11	96.5001591	63.08	SEVERE STORM AND FLOODING	Flood	4
4609	47081	2021-08-23	1	1	1	4.308486e+04	43084.86	1.218100e+02	2021	24872	4.530279e+09	47.5660197	14.51	SEVERE STORM AND FLOODING	Flood	4
4609	47085	2021-08-23	12	4	4	5.117235e+06	4202070.67	2.209380e+05	2021	18964	3.290526e+09	43.5252943	51.88	SEVERE STORM AND FLOODING	Flood	4
4601	47187	2021-05-08	1	1	1	9.670780e+03	9670.78	1.680000e+02	2021	247523	5.469015e+10	77.9828190	86.19	SEVERE STORMS, TORNADOES, AND FLOODING	Tornado	4
4601	47189	2021-05-08	1	1	1	6.529950e+03	6529.95	4.259168e+05	2021	147693	2.799064e+10	79.7009227	66.07	SEVERE STORMS, TORNADOES, AND FLOODING	Tornado	4
4586	48167	2021-02-19	2	2	2	8.389754e+04	83897.54	3.464100e+03	2021	350477	5.674698e+10	99.5227490	90.36	SEVERE WINTER STORMS	Severe Ice Storm	6
4578	49011	2021-01-12	2	2	2	2.270630e+05	227062.95	6.985800e+03	2021	362649	4.792347e+10	93.7957366	98.31	STRAIGHT-LINE WINDS	Severe Storm	8
4628	51027	2021-10-26	1	1	1	2.926114e+05	292611.44	1.100000e+01	2021	20340	2.256744e+09	46.8024181	3.63	FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	3
4628	51760	2021-10-26	1	1	1	3.528272e+05	352827.20	8.500000e+01	2021	226269	4.353533e+10	73.2421254	54.84	FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	3
4584	53021	2021-02-04	1	1	1	1.142333e+04	11423.33	5.110000e+03	2021	96653	1.402875e+10	68.4696150	28.61	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	10
4593	53047	2021-04-08	1	1	1	3.682250e+03	3682.25	8.000000e+00	2021	42016	9.411749e+09	85.0779510	19.70	SEVERE WINTER STORM, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	10
4584	53053	2021-02-04	1	1	1	4.567225e+06	4567224.89	1.277000e+03	2021	920483	1.607052e+11	98.7273306	70.56	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	10
4584	53075	2021-02-04	2	2	2	8.158387e+04	81583.87	2.593900e+04	2021	47922	9.223151e+09	23.8307350	43.48	WILDFIRES AND STRAIGHT-LINE WINDS	Fire	10
4672	02180	2022-09-23	1	1	1	5.482220e+03	5482.22	5.000000e+01	2022	10031	1.993288e+09	3.4043907	25.18	SEVERE STORM, FLOODING, AND LANDSLIDES	Severe Storm	10
4673	12009	2022-09-29	2	2	2	2.011795e+05	201179.46	2.137500e+02	2022	606067	1.055946e+11	99.3636653	59.83	HURRICANE IAN	Hurricane	4
4673	12015	2022-09-29	6	6	6	4.226326e+07	42263262.65	5.860211e+05	2022	186734	3.146261e+10	96.5956093	11.94	HURRICANE IAN	Hurricane	4
4673	12021	2022-09-29	7	4	4	1.071419e+08	53598049.05	1.068079e+06	2022	375443	8.254240e+10	98.8545975	20.15	HURRICANE IAN	Hurricane	4
4673	12027	2022-09-29	3	3	3	1.591684e+07	15916838.67	5.358010e+04	2022	33898	5.358888e+09	90.4231626	1.11	HURRICANE IAN	Hurricane	4
4673	12049	2022-09-29	1	1	1	4.906879e+06	4906879.32	9.000000e+03	2022	25302	3.815820e+09	80.2736239	3.53	HURRICANE IAN	Hurricane	4
4673	12051	2022-09-29	1	1	1	2.348518e+05	234851.81	1.280000e+02	2022	39371	6.080710e+09	91.1549475	0.89	HURRICANE IAN	Hurricane	4
4673	12055	2022-09-29	3	3	3	8.649117e+06	8649116.66	1.072570e+04	2022	101136	1.753236e+10	90.2958956	4.81	HURRICANE IAN	Hurricane	4
4673	12069	2022-09-29	1	1	1	2.741030e+05	274103.02	1.590000e+02	2022	383042	5.896930e+10	95.2274897	48.09	HURRICANE IAN	Hurricane	4
4673	12071	2022-09-29	21	18	18	1.530937e+08	153093719.52	1.775402e+06	2022	759922	1.233084e+11	99.4909322	9.17	HURRICANE IAN	Hurricane	4
4673	12073	2022-09-29	33	18	18	3.930296e+08	250301311.25	6.847536e+06	2022	292157	4.688315e+10	94.5593382	74.76	HURRICANE IAN	Hurricane	4
4673	12081	2022-09-29	4	4	4	1.391334e+07	13913335.48	6.184630e+03	2022	399485	6.672028e+10	98.4409800	23.90	HURRICANE IAN	Hurricane	4
4673	12087	2022-09-29	2	2	2	1.693228e+06	1693227.63	1.323848e+04	2022	82390	1.808080e+10	95.9274578	27.88	HURRICANE IAN	Hurricane	4
4673	12093	2022-09-29	2	2	2	4.217873e+06	4217873.08	5.363350e+03	2022	39455	6.060952e+09	87.5914731	2.42	HURRICANE IAN	Hurricane	4
4673	12095	2022-09-29	3	3	3	2.876846e+06	2876846.22	1.024580e+04	2022	1428790	2.324704e+11	98.5682469	43.92	HURRICANE IAN	Hurricane	4
4673	12097	2022-09-29	3	3	3	7.045912e+05	704591.23	1.132150e+04	2022	387795	5.045786e+10	95.1320395	35.74	HURRICANE IAN	Hurricane	4
4680	12099	2022-12-13	1	1	1	1.125666e+05	112566.65	4.880000e+01	2022	1489461	2.385678e+11	99.7136494	23.65	HURRICANE NICOLE	Hurricane	4
4673	12103	2022-09-29	2	2	2	1.324950e+05	132495.00	3.611600e+02	2022	958822	1.452981e+11	99.2045816	12.00	HURRICANE IAN	Hurricane	4
4673	12109	2022-09-29	2	2	2	7.317271e+05	731727.09	3.242650e+03	2022	273175	5.135085e+10	94.1457206	81.99	HURRICANE IAN	Hurricane	4
4680	12111	2022-12-13	1	1	1	4.950000e+03	4950.00	9.000000e+00	2022	328876	4.431051e+10	98.3137130	46.21	HURRICANE NICOLE	Hurricane	4
4673	12115	2022-09-29	9	9	8	2.624248e+07	26242484.88	9.647222e+04	2022	433908	8.064207e+10	98.4091632	9.23	HURRICANE IAN	Hurricane	4
4673	12117	2022-09-29	6	6	6	9.515614e+06	9515614.45	8.698750e+03	2022	470586	7.253923e+10	95.6411072	64.58	HURRICANE IAN	Hurricane	4
4673	12119	2022-09-29	1	1	1	6.906994e+04	69069.94	1.000000e+01	2022	129698	2.082162e+10	88.9277760	38.67	HURRICANE IAN	Hurricane	4
4673	12127	2022-09-29	15	15	15	1.633062e+07	16330624.32	2.140567e+05	2022	551829	8.247022e+10	97.5182946	45.64	HURRICANE IAN	Hurricane	4
4642	19067	2022-02-23	1	1	1	1.589096e+04	0.00	2.623704e+02	2022	15615	3.686895e+09	42.9525931	86.76	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	7
4640	20053	2022-02-17	1	1	1	1.400319e+04	14003.19	1.120000e+02	2022	6367	2.468475e+09	40.0254534	59.36	SEVERE STORMS AND STRAIGHT LINE WINDS	Severe Storm	7
4640	20169	2022-02-17	1	1	1	3.983770e+03	3983.77	1.900000e+01	2022	54303	1.186593e+10	77.8873688	86.38	SEVERE STORMS AND STRAIGHT LINE WINDS	Severe Storm	7
4663	21025	2022-07-29	8	5	5	2.769438e+05	183864.59	9.392259e+04	2022	13610	1.933137e+09	29.8759147	2.77	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4663	21073	2022-07-29	5	5	5	5.998917e+07	59989172.12	1.014424e+06	2022	51521	1.006136e+10	62.8062361	71.55	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4663	21133	2022-07-29	3	3	3	2.431930e+05	243192.99	1.498740e+04	2022	21438	3.854601e+09	29.8440980	5.25	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4663	21159	2022-07-29	1	1	1	1.793846e+04	17938.46	9.372000e+01	2022	11285	1.444151e+09	33.6302895	1.65	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	4
4658	27001	2022-07-08	1	1	1	1.497580e+04	14975.80	5.000000e+02	2022	15674	5.084602e+09	10.6904232	95.96	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4666	27007	2022-08-09	1	1	1	1.079546e+04	10795.46	5.000000e+01	2022	46103	1.173116e+10	36.3028953	88.96	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4666	27041	2022-08-09	1	1	1	9.137020e+03	9137.02	1.503800e+02	2022	38992	1.160771e+10	31.9121858	97.96	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4659	27071	2022-07-13	1	1	1	8.733919e+05	873391.90	1.350000e+02	2022	12059	2.782644e+09	0.6681514	85.65	SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING	Flood	5
4658	27073	2022-07-08	1	1	1	2.950788e+04	29507.88	5.400000e+02	2022	6711	2.455724e+09	14.7947821	86.16	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4658	27123	2022-07-08	1	1	1	6.467121e+04	64671.21	1.200000e+02	2022	552246	1.001147e+11	92.1094496	95.07	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4658	27149	2022-07-08	1	1	1	3.313251e+04	33132.51	3.000000e+00	2022	9670	3.506548e+09	14.6675151	93.92	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4666	27159	2022-08-09	1	1	1	5.376360e+03	5376.36	1.000000e+03	2022	14054	3.447234e+09	16.1947184	85.81	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	5
4665	29183	2022-08-08	3	3	3	1.106059e+05	110605.87	1.571400e+04	2022	405183	8.092181e+10	93.0003182	96.24	SEVERE STORMS AND FLOODING	Flood	7
4665	29189	2022-08-08	1	1	1	3.694460e+03	3694.46	4.000000e+01	2022	1003734	2.351181e+11	98.5364302	77.66	SEVERE STORMS AND FLOODING	Flood	7
4665	29510	2022-08-08	1	1	1	9.184803e+04	91848.03	4.000000e+01	2022	301414	6.615276e+10	95.3547566	61.14	SEVERE STORMS AND FLOODING	Flood	7
4655	30049	2022-06-16	4	1	1	1.849497e+07	9247486.18	1.306541e+06	2022	70922	1.384361e+10	51.1613108	76.61	SEVERE STORM AND FLOODING	Flood	8
4655	30067	2022-06-16	3	3	3	1.112039e+05	111203.85	1.962795e+04	2022	17153	5.181397e+09	23.7352848	76.51	SEVERE STORM AND FLOODING	Flood	8
4662	31107	2022-07-27	1	1	1	9.793602e+04	11300.00	1.300000e+02	2022	8383	3.127981e+09	35.8574610	47.71	SEVERE STORMS AND STRAIGHT-LINE WINDS	Severe Storm	7
4652	35049	2022-05-05	1	1	1	2.042694e+07	20426936.70	4.000000e+03	2022	154509	3.089753e+10	81.1963093	34.21	WILDFIRES, STRAIGHT-LINE WINDS, FLOODING, MUDFLOWS, AND DEBRIS FLOWS	Fire	6
4677	45019	2022-11-21	3	3	3	1.453644e+06	1453644.48	1.643896e+04	2022	407722	8.599560e+10	99.4591155	92.71	HURRICANE IAN	Hurricane	4
4677	45043	2022-11-21	3	3	3	8.231594e+04	82315.94	3.525200e+02	2022	63262	1.409163e+10	95.2593064	58.59	HURRICANE IAN	Hurricane	4
4677	45051	2022-11-21	1	1	1	1.352706e+05	135270.62	3.200000e+01	2022	348574	6.455071e+10	98.9818645	61.30	HURRICANE IAN	Hurricane	4
4677	45079	2022-11-21	2	2	2	9.290531e+05	929053.06	4.222000e+03	2022	415644	8.168495e+10	93.3503023	74.19	HURRICANE IAN	Hurricane	4
4656	46009	2022-06-29	1	1	1	4.543667e+04	45436.67	6.225000e+02	2022	6996	2.156272e+09	17.1174038	58.63	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46011	2022-06-29	1	1	1	2.225375e+04	22253.75	1.600000e+02	2022	34375	1.010820e+10	76.2965320	74.00	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46057	2022-06-29	1	1	1	2.860099e+05	286009.86	3.328810e+03	2022	6164	2.428631e+09	33.9484569	79.09	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46065	2022-06-29	1	1	1	1.104682e+05	110468.23	3.773000e+03	2022	17751	3.816304e+09	47.1205854	85.90	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46077	2022-06-29	1	1	1	1.252497e+05	125249.72	6.525000e+02	2022	5183	2.874478e+09	33.7257397	91.57	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46087	2022-06-29	2	2	2	2.326145e+05	232614.46	2.944140e+03	2022	5682	1.196086e+10	69.1059497	88.70	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46099	2022-06-29	2	2	2	2.198004e+05	219800.43	7.542000e+02	2022	196891	3.733547e+10	92.5867006	93.13	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4656	46101	2022-06-29	1	1	1	7.411780e+03	7411.78	5.000000e+01	2022	6336	3.337204e+09	53.2930321	74.35	SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING	Severe Storm	8
4637	47037	2022-01-14	3	3	3	1.223647e+06	1223647.28	1.823000e+03	2022	715485	1.402987e+11	96.5001591	63.08	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	4
4637	47043	2022-01-14	1	1	1	2.417185e+05	241718.45	4.200000e+02	2022	54292	8.838771e+09	64.8425072	45.16	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	4
4637	47131	2022-01-14	4	1	1	3.045821e+05	152291.06	1.122222e+04	2022	30777	4.898492e+09	77.7601018	36.76	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	4
4637	47183	2022-01-14	9	1	1	2.955783e+07	9852608.79	2.925000e+05	2022	32891	5.108212e+09	78.4918867	31.19	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	4
4674	51760	2022-09-30	1	1	1	1.720723e+06	1720722.95	6.744000e+03	2022	226269	4.353533e+10	73.2421254	54.84	FLOODING AND MUDSLIDES	Severe Storm	3
4650	53021	2022-03-29	1	1	1	8.176734e+04	81767.34	3.600000e+02	2022	96653	1.402875e+10	68.4696150	28.61	SEVERE WINTER STORMS, SNOWSTORMS, STRAIGHT-LINE WINDS, FLOODIN	Flood	10
4635	53057	2022-01-05	1	1	1	6.477661e+04	64776.61	2.431746e+04	2022	129360	2.649981e+10	89.1186764	77.02	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4635	53073	2022-01-05	5	2	1	3.715787e+05	311774.71	1.801400e+05	2022	226681	4.568536e+10	90.9322304	79.50	SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	10
4679	54019	2022-11-28	1	1	1	5.311186e+04	53111.86	4.870600e+02	2022	40383	5.823612e+09	24.7534203	26.61	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	3
4671	72005	2022-09-21	1	1	1	9.574480e+03	9574.48	6.000000e+00	2022	54977	9.841042e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72009	2022-09-21	1	1	1	6.721767e+05	672176.66	1.600000e+04	2022	24637	3.015895e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72011	2022-09-21	1	1	1	1.237893e+06	1237893.47	8.295000e+02	2022	25546	3.097504e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72027	2022-09-21	1	1	1	7.468564e+05	746856.39	8.116600e+02	2022	32797	3.642558e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72031	2022-09-21	1	1	1	6.234365e+04	62343.65	4.000000e+02	2022	154696	2.283049e+10	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72059	2022-09-21	1	1	1	8.633778e+05	863377.78	6.711000e+02	2022	17690	1.798984e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72105	2022-09-21	1	1	1	2.860372e+05	286037.25	1.009000e+02	2022	29241	2.934399e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72109	2022-09-21	1	1	1	2.258948e+06	2258948.25	3.930802e+04	2022	15929	2.009534e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72111	2022-09-21	2	2	2	4.559558e+06	4559557.59	2.068581e+04	2022	20320	2.518446e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72117	2022-09-21	1	1	1	1.232206e+05	123220.62	5.532000e+02	2022	15187	2.056385e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4671	72153	2022-09-21	1	1	1	9.287350e+05	928735.00	2.809000e+03	2022	34151	3.045488e+09	NA	NA	HURRICANE FIONA	Hurricane	2
4684	01001	2023-01-15	4	1	1	3.067286e+06	1533642.78	4.256000e+03	2023	58764	9.123274e+09	49.2204900	51.81	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01017	2023-01-15	2	2	2	1.655437e+05	165543.74	4.200000e+01	2023	34738	5.993491e+09	42.3480751	40.13	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01047	2023-01-15	5	5	5	7.667066e+06	7667065.61	9.147565e+04	2023	38341	6.955631e+09	57.8428253	44.21	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01051	2023-01-15	1	1	1	2.624263e+05	262426.34	1.287000e+03	2023	87755	1.251095e+10	57.2701241	57.07	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01063	2023-01-15	2	2	2	4.183933e+05	418393.30	2.392800e+02	2023	7714	1.339905e+09	18.0400891	5.98	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01065	2023-01-15	2	2	2	3.015091e+05	301509.11	1.260400e+03	2023	14753	2.427858e+09	33.1530385	13.40	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01101	2023-01-15	2	2	2	1.423541e+06	1423541.34	3.996000e+03	2023	228847	4.622347e+10	86.2551702	67.92	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01119	2023-01-15	2	2	2	5.275280e+04	52752.80	4.354500e+02	2023	12322	3.236461e+09	51.0658606	7.54	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4684	01123	2023-01-15	1	1	1	4.998020e+04	49980.20	1.200000e+03	2023	41279	8.545817e+09	50.0477251	43.25	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4698	05037	2023-04-02	6	3	3	2.071781e+07	10704864.50	3.360577e+05	2023	16824	3.357621e+09	66.4969774	33.64	SEVERE STORMS AND TORNADOES	Severe Storm	6
4698	05119	2023-04-02	1	1	1	3.806886e+05	380688.64	1.059500e+04	2023	398830	7.392333e+10	95.0684060	73.68	SEVERE STORMS AND TORNADOES	Severe Storm	6
4683	06085	2023-01-14	1	1	1	1.337007e+05	133700.70	1.500000e+01	2023	1934625	3.815867e+11	99.8409163	68.94	SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	9
4709	12011	2023-04-27	1	1	1	1.540372e+06	1540372.01	4.170200e+04	2023	1940829	2.681728e+11	99.7454661	44.84	SEVERE STORMS, TORNADOES, AND FLOODING	Flood	4
4734	12017	2023-08-31	3	3	3	1.434055e+06	1434055.44	8.128043e+04	2023	153476	2.146307e+10	95.8956411	7.13	HURRICANE IDALIA	Hurricane	4
4734	12075	2023-08-31	2	2	2	1.062832e+06	1062831.95	4.746850e+04	2023	42750	4.701759e+09	83.2643971	8.40	HURRICANE IDALIA	Hurricane	4
4734	12101	2023-08-31	3	3	3	1.103308e+05	110330.80	1.611960e+03	2023	561566	8.980181e+10	99.0454979	13.21	HURRICANE IDALIA	Hurricane	4
4734	12103	2023-08-31	3	3	3	7.846824e+04	78468.24	5.098200e+02	2023	958822	1.452981e+11	99.2045816	12.00	HURRICANE IDALIA	Hurricane	4
4685	13035	2023-01-16	1	1	1	2.599814e+06	2599813.53	2.117000e+02	2023	25426	3.890726e+09	16.6083360	42.46	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4738	13075	2023-09-07	1	1	1	1.687436e+05	168743.57	8.300000e+01	2023	17209	3.573371e+09	60.0381801	33.83	HURRICANE IDALIA	Hurricane	4
4738	13185	2023-09-07	1	1	1	4.758775e+06	4758774.53	6.000000e+01	2023	118124	2.074955e+10	81.3553929	42.20	HURRICANE IDALIA	Hurricane	4
4685	13255	2023-01-16	4	4	4	6.697894e+06	6697893.83	5.685100e+03	2023	67247	1.203496e+10	44.8615972	40.20	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4685	13285	2023-01-16	1	1	1	1.250307e+04	12503.07	1.152000e+03	2023	69343	1.439801e+10	67.3242125	46.02	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4704	18007	2023-04-15	1	1	1	1.208304e+04	12083.04	8.646000e+03	2023	8719	2.087997e+09	11.1358575	62.35	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	5
4704	18023	2023-04-15	1	1	1	6.632260e+03	6632.26	2.193614e+01	2023	33183	5.454152e+09	40.0572701	71.07	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	5
4704	18081	2023-04-15	2	2	2	1.430079e+04	13300.79	6.262000e+02	2023	161668	3.055103e+10	81.7371938	88.86	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	5
4704	18109	2023-04-15	1	1	1	9.961140e+04	99611.40	6.060000e+03	2023	71729	1.362281e+10	62.5835189	78.80	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	5
4702	21073	2023-04-10	1	1	1	1.150672e+05	115067.20	8.000000e+01	2023	51521	1.006136e+10	62.8062361	71.55	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	4
4702	21155	2023-04-10	1	1	1	6.451137e+04	64511.37	2.724600e+02	2023	19521	4.044451e+09	33.3439389	61.90	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	4
4702	21203	2023-04-10	1	1	1	8.287000e+03	0.00	6.000000e+01	2023	16028	2.658793e+09	17.6901050	20.66	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	4
4702	21227	2023-04-10	1	1	1	2.064716e+05	206471.58	1.124000e+02	2023	134482	2.463868e+10	83.0098632	64.99	SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES	Severe Storm	4
4696	23013	2023-03-22	1	1	1	8.691740e+03	8691.74	1.400000e+01	2023	40597	9.304553e+09	50.4931594	97.61	SEVERE STORM AND FLOODING	Severe Storm	1
4696	23031	2023-03-22	1	1	1	2.426894e+04	24268.94	2.000000e+01	2023	211925	4.450945e+10	83.6143812	85.84	SEVERE STORM AND FLOODING	Severe Storm	1
4697	28015	2023-03-26	1	1	1	5.004668e+05	500466.78	3.118400e+03	2023	9971	1.639614e+09	16.0674515	26.26	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4727	28059	2023-08-12	1	1	1	7.718024e+05	771802.42	1.481796e+04	2023	143149	2.306976e+10	95.9910913	75.88	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES.	Severe Storm	4
4697	28095	2023-03-26	12	6	6	2.967720e+07	19139114.29	1.972424e+05	2023	34055	5.885635e+09	63.0607700	43.76	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4697	28097	2023-03-26	1	1	1	3.707440e+04	37074.40	7.224000e+01	2023	9775	1.587660e+09	22.2717149	27.59	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4697	28125	2023-03-26	4	4	4	1.078583e+07	10785827.85	4.687428e+05	2023	3773	7.697461e+08	29.0486796	25.46	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4697	28149	2023-03-26	1	1	1	1.000000e+04	10000.00	2.000000e+01	2023	44654	9.795010e+09	76.5192491	68.11	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4725	34041	2023-08-11	1	1	1	4.173197e+05	417319.66	6.346000e+03	2023	109580	2.614011e+10	75.3102132	84.12	SEVERE STORM AND FLOODING	Severe Storm	2
4706	40125	2023-04-24	1	1	1	4.336627e+06	4336627.23	2.172210e+04	2023	72357	8.784389e+09	85.9051861	51.85	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Tornado	6
4701	47015	2023-04-07	1	1	1	1.541853e+05	154185.33	1.250000e+04	2023	14490	2.125417e+09	18.8355075	26.67	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4701	47071	2023-04-07	1	1	1	2.393908e+05	239390.75	9.500000e+02	2023	26745	4.834413e+09	52.4021635	34.09	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4701	47149	2023-04-07	1	1	1	1.144501e+05	114450.07	6.318400e+02	2023	341253	6.433455e+10	88.2278078	70.53	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4751	47165	2023-12-13	1	1	1	2.074564e+05	207456.41	1.800474e+00	2023	196179	3.417330e+10	83.3598473	57.54	SEVERE STORMS AND TORNADOES	Severe Storm	4
4701	47167	2023-04-07	5	2	2	6.118566e+06	3362144.66	6.664860e+04	2023	60942	8.944088e+09	80.3372574	56.27	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4701	47181	2023-04-07	2	2	2	5.857980e+05	585797.97	1.340000e+03	2023	16204	2.124535e+09	44.6706968	11.39	SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES	Severe Storm	4
4720	50023	2023-07-14	6	6	6	1.871425e+06	1871424.72	8.999176e+04	2023	59777	1.290725e+10	56.7610563	90.87	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	1
4720	50025	2023-07-14	3	3	3	2.713912e+04	27139.12	1.853500e+02	2023	45853	1.231266e+10	48.6159720	69.76	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	1
4720	50027	2023-07-14	1	1	1	1.363750e+04	13637.50	6.684800e+02	2023	57706	1.478996e+10	56.9201400	67.00	SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES	Flood	1

1.3.2 The Data Summary

## [1] 319.7977

##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   28.98  117.58     Inf  495.34     Inf

Minimum, Central Tendency and Quartile Points. The first quartile value 29 dollars, is close to the currently used value of 35 dollars per yard of Construction Debris removal.

Median Cost is at 117 dollars. The Mean value is not calculated here, because projects with 0 values (for quantity) create an error. The trimmed mean (which removes the outlier/errors) is $319.

The Mean is skewed by extremely high cost projects. This is why we log (exponentially) scale quantity and cost in most of the analysis.

1.3.3 Viewing that summary:

Again, we see that Region 4 looks similar to others, so we can attempt to use all the data in grants manager to fit a more robust relationship.

1.3.4 The Cost & Quantity Relationship

• Here Region 4 is shown as a separate color, however, it is very similar to the spread of other projects.
• Note: We have removed extreme outliers from this chart already.
• This chart is interactive if you are viewing in your browser.

1.3.5 Formulas Explained

• Just like for Vegetative Debris, I’ve fit a line through this data cloud, and the converted that to a formula that can be used to estimate costs.
• Slope intercept formula converted to log-log format is:
• \(log10(y) = intercept + slope * log10(x)\)
• Example for 10000 Cubic Yards
• \(log10(10000) ~= 2.175 + .925 * log10(100)\)
• \(4 ~= 2.175 + .925 * 2\)

(Actual answer for 100 cubic yards = 4.025, so 10^4.025 = $10592.54 Formula for CY \(10^ (log10(Cubic Yards) *.925 + 2.175)\)

Note: I fit this relationship… with an eye test. An actual regression relationship fit to this is… below. The numbers come out slightly different, but it’s a reasonable approximation.

1.3.6 Regression Fitting

cd_model <- cd_pred_MT %>% 
filter(Quantity > 10, 
       Gross_Cost < 1.25e08,
       is.na(Quantity)==FALSE,
       is.na(Gross_Cost)==FALSE) %>% 
    lm(formula = log10(1+Gross_Cost) ~ log10(1+Quantity))

summary(cd_model)

## 
## Call:
## lm(formula = log10(1 + Gross_Cost) ~ log10(1 + Quantity), data = .)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -4.6563 -0.5803  0.0339  0.6386  2.6086 
## 
## Coefficients:
##                     Estimate Std. Error t value Pr(>|t|)    
## (Intercept)          3.56817    0.11169   31.95   <2e-16 ***
## log10(1 + Quantity)  0.54892    0.02945   18.64   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.8992 on 592 degrees of freedom
## Multiple R-squared:  0.3698, Adjusted R-squared:  0.3688 
## F-statistic: 347.4 on 1 and 592 DF,  p-value: < 2.2e-16

Notes: - The model is *okay. SIgnificant fit, moderate R^2. - There is a lot of variance in trying to fit a single straight line through the widely disperesed cloud, so on either end, we have large residiuals (the difference between the line and data points). - A formula derived from this could be good in the aggregate but could be off by a lot for individual predictions.

1.3.7 Creating Functions to Show the Estimates

cy_eye_formula <- function(CY){
  10^ (log10(CY) *.925 + 2.175)
}

cy_reg_formula <- function(CY){
  10^(log10(CY)*0.54892  + 3.56817)
}

cy_reg_formula(100)

## [1] 46345.76

#46345.76
cy_eye_formula(100)

## [1] 10592.54

#10592.54

1.3.8 The differences in how these two relationships predict:

• If we want to choose one that undershoots costs - we can go with Blue line.
• This is what our Region 4 POCs preferred, as they would rather underestimate costs since this is being used in pre-declaration assessment to determine if a given county will get declared or not.

1.3.9 Formula Predictions v Actuals

1.3.9.1 Notes:

• The blue line is the ‘Regression Predictions’ (reg_preds)‘, red line is the ’Eye Prediction’ (eye_pred)
• The chart is interactive.
• They are slightly differently balanced, in my opinion, the eye prediction formula should be preferred under 500-8000 Cubic Yards of quantity, then the regression predictor satisfies Region 4’s approach better at higher numbers of Cubic Yardage to be removed.
• The formula promoted in the BLUF section uses the regression formula.

---

1.4 Appendix

---

---

1.4.1 Assessing Historials as Predictors in Complex Model

# load(file="historicals.rda")
# #glimpse(hist)
# names(hist) <- gsub(names(hist), pattern = " ", replacement = "_")
# hist[,3:51] <- lapply(hist[,3:51],FUN = as.numeric)
# 
# veg_pred.m.hist <- left_join(veg_pred.m, hist, by="FIPS")
# veg_pred.m.hist$year <- factor(veg_pred.m.hist$year, ordered=T)
# veg_pred.m.hist$USPS <- factor(veg_pred.m.hist$USPS, ordered=F)
# 
# cor.test(veg_pred.m.hist$Gross_Cost, veg_pred.m.hist$`Historical_Vegetative_75th_Quantile_Gross_Cost.75%`)
# #0.24, fairly weak...
# 
# #library(lme4)
# veg_multi_mod <- 
#   veg_pred.m.hist %>% filter(
#     Quantity > 10,
#     Gross_Cost > 500,
#     Gross_Cost < 1e07) %>% 
#   lme4::lmer(formula = log10(Gross_Cost) ~ log10(Quantity) +
#              `Historical_Vegetative_75th_Quantile_Gross_Cost.75%` 
#              + year
#              + (1|USPS))
# 
# summary(veg_multi_mod)
# 
# 
# #veg_lm_mod_state <- 
# #  veg_pred.m.hist %>% filter(
# #    Quantity > 10,
# #    Gross_Cost > 500,
# #    Gross_Cost < 1e07) %>% 
# #  lm(formula = log10(Gross_Cost) ~ log10(Quantity) + USPS)
# 
# #summary(veg_lm_mod_state)  # state not a useful variable. 

Successful modeling, but not really adding much of significance. Would need to evalauate a larger field of predictors, particularly those that don’t come from GM (cross contamination data, since the 75th for costs are some composite from the predictand anyway…)

# piecewiseSEM::rsquared(veg_multi_mod) 
# piecewiseSEM::rsquared(veg_model)

#LOWER RSQUARED than the simple model, no reason to do a complex process for what we may think (but can’t really prove) are different, nested structures influencing this process. States/Counties are more alike than different… is the simple conclusion.

The idea here would be to have separate intercepts for each state (or if we could get down to it… each county) as R4 would like multipliers or factors for states and counties where the number is higher… lower etc…

At least in this model, the differences aren’t too meaningful.

---

---

1.4.2 Additional Data Views and Visualization.

1.4.2.1 Project Based Aggregation and Exploration

# load("input_tables/Vegetative_Debris_CY_Debris_Data_By_Applicant_Project_Id.rda", verbose=T)
# glimpse(CY_Debris_Data_By_Applicant_Project_Id)
# 
# veg_stat <- CY_Debris_Data_By_Applicant_Project_Id %>% 
#   group_by(State, County, Applicant_Project_Id) %>% summarise(
#     .groups = "keep",
#     Gross_Cost = max(Gross_Cost, na.rm=T),
#     Quantity = sum(Quantity, na.rm=T)
#   ) %>% 
#   ungroup()
# glimpse(veg_stat)

CTA: Previous work made this look like an exponential or power law relationship, attempting to fix exponential/poly models and see how close they fit the line, could use that as a product for the R4 group. (There is still a large error term..)

Look at fitting various exponential relationships